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:
- Select the Sage Intelligence formula you want to change.
- In the formula bar, enter a minus sign after the equals and before the GL portion of the function.
- 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.