Year over Year Growth

Previous Contributor

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.

Message 1 of 5
4 REPLIES 4
Previous Contributor

RE: Year over Year Growth

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)-1
Message 2 of 5
Previous Contributor

RE: Year over Year Growth

That works perfectly. Thanks for the help!
Message 3 of 5
Previous Contributor

RE: Year over Year Growth

No worries.  I hope that growth calc gives a +ve answer!
Message 4 of 5
Contributor

Re: Year over Year Growth

I would also recommend considering the LAG formula, which may not have been available when this was first posted.

Message 5 of 5