Yearly ESCALATION calculation

DMManalili
DMManalili
in Modeling

Hi, would like to ask on how can show the escalation yearly amount? for example FY21, the amount is 10M and for FY22 the amount should be 10M x 1.1 = 11M. Please see screenshots below. Thank you

 

anaplan

DMManalili_0-1603328900932.png

excel: should be amount

DMManalili_1-1603328909703.png

 

 

 

 

Tagged:

Best Answer

  • anirudh
    anirudh
    Answer ✓

    Try this instead, in the Escalation line item:
    IF ITEM(Time) = Time.'FY21' THEN Calc Yearly Amount - Calculate ELSE PREVIOUS(Calc Year Amount - Escalation) * 1.1

    If this works, replace the hardcoding of Time.'FY21' to a lookup

    Regards,
    Anirudh

Answers

Categories