Passer au contenu principal


Workday Adaptive Planning Knowledge Center

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


  • Cet article vous a été utile ?