How to Create a Formula to Show Year-Over-Year Growth %
- Create a Custom Account that refers to the GL Account (or other type of account) from 12 months prior. The time and level rollup settings would be set to sum. For example, the formula could look similar to the one below.
CUSTOM = ACCT.EXPENSES[TIME=THIS-1]
(The rollups in the current year should then be equal to the rollups in the previous year)
- Create a Metric Account that calculates the year over year growth. This would allow for the rollups to correctly refer to the rollups in the previous period. Make sure to set the Display type to percent.
EXPENSE YOY = DIV((ACCT.EXPENSES-ACCT.CUSTOM),ACCT.CUSTOM)