Year over Year Growth
Hi - I'm trying to calculate year over year growth in the time summary lines for my fiscal years. I can calculate year/year growth for each quarter (we are viewing our year by qtr only) using the offset function - (Revenue - OFFSET(Revenue, -4, 1)) / OFFSET(Revenue, -4, 1). However, Anaplan doesnt' allow the offset function to be used in the summary formula. Any suggestions? Thanks.
Tagged:
0
Best Answer
-
I guess the easiest thing is to set up a new line item for 'Prior Year Revenue' which is OFFSET(Revenue,-4,1) ... (or could be POST(Revenue,4).
And then have Growth = (Revenue/Prior Year Revenue)-11
Answers
-
That works perfectly. Thanks for the help!0
-
No worries. I hope that growth calc gives a +ve answer!0
-
I would also recommend considering the LAG formula, which may not have been available when this was first posted.
1
