How to reverse the sign of an account in your Sage Intelligence Financial Report Designer

In the Sage Intelligence Financial Report Designer, account balances are returned in their “natural format” from your Sage accounting or business management solution.  Therefore, credit accounts (with a credit balance) are shown as negative values and debit accounts (with a debit balance) are shown as positives values.  However, in financial reporting, there are times when the natural format does not suit the format of your reports, so it is necessary to reverse the sign.

Applies to: The Sage Intelligence Financial Report Designer

As an example, in an Income Statement, Revenue is naturally a credit account, and so it will be seen as a negative amount after the Sage Intelligence formula is dragged in for the row and its arguments configured.  This will also impact any other formulas in the layout that depend on it, like Variance and Gross Profit.

It, therefore, makes sense to reverse the sign of the Sage Intelligence formulas in the row.  For this, all you have to do is the following:

  1. Select the Sage Intelligence formula you want to change.
  2. In the formula bar, enter a minus sign after the equals and before the GL portion of the function.
  3. Press Enter to confirm the change.

The results will now be negated. In other words, the credit balances will be shown as positive values, making the layout easier to interpret and other formulas more natural to calculate.