YoY Growth Calculation - Dataflow
Hello,
I am trying to create a dataflow that would apply a % growth YoY (See example table below with 2% YoY growth).
There would be a data entry say on 2025 and then it will trigger the YoY Growth calculation. I tried using the "Period by period recursion" but it is applying the % growth on MoM.
Can anyone please help on how to set up the dataflow so it would calculate YoY growth instead of the MoM?
Staff | 2025 | 2026 | 2027 |
|---|---|---|---|
Staff 1 | 100,000 | 102,000 | 104,040 |
Accepted Answers
-
If you cube is structured by month entity the period -1 is 1 one month prior. You can either do the Prior Year on the first Block, or a Period -12 (if you only have 12 months).
Hope that helps.
Bart Scott
CFO Solutions LLC
1 -
Hi @Efraim,
As Bart correctly explained above, the "Offset" function will reference a specified number of periods based on the dimensions of your cube. In your case, since the cube is dimensioned by Month, you'll need to set the offset to -12 in order to reference the same month from the previous year for each Month in the cube. If your cube were dimensioned by Year, an offset of -1 would suffice.
Kind regards,
Hamza
0
Answers
-
Hello both, thanks for the answer!
I used the -12 offset and it's working now when "Period by period recursion" is used
1