Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Reports: Reverse Sign Alternatives

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

 

  • Was this article helpful?