Skip to main content


Adaptive Insights LLC.

Reverse Sign for Non GL Accounts in Reports


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?


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:


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?