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.

Best Answer

  • PrevContributor
    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