Reverse Sign for Non GL Accounts in Reports
Question
Since the reverse sign feature in Reports only applies to GL Accounts, how do I reverse the sign of other types of accounts in my Matrix Report?
Answer
The reverse sign feature in reports only applies to GL accounts so if you have other types of accounts in your matrix report you can consider using a custom calculation from the left pane in the report builder.
Example A:
-1*ACCT.Example
Example B:
if([Budget]<[Actuals], div(([Budget]-[Actuals])/[Actuals])*-1, div(([Budget]-[Actuals])/[Actuals]))
Translation: If the Budget value is less than Actuals, then take the variance and multiple by negative one, otherwise just take the variance