Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

How to Create a Formula to Show Year-Over-Year Growth Percent

  1. 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) 
     
  2. 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)
  • Was this article helpful?