Yearly ESCALATION calculation

Highlighted
Contributor

Yearly ESCALATION calculation

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

 

 

 

 

5 REPLIES 5
Highlighted
Master Anaplanner/Community Boss

Re: Yearly ESCALATION calculation

Try

PREVIOUS('Calc Yearly Amount - Cumulate) * 1.1
This will work only if the line item item is dimensioned by Year timescale

Regards,
Anirudh
Highlighted
Contributor

Re: Yearly ESCALATION calculation

hi anirudh,

its the same figure i got. please see ss below. thank you

 

DMManalili_0-1603338900648.png

 

Highlighted
Master Anaplanner/Community Boss

Re: Yearly ESCALATION calculation

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

Highlighted
Contributor

Re: Yearly ESCALATION calculation

yes it works,, thank you 🙂
Highlighted
Master Anaplanner/Community Boss

Re: Yearly ESCALATION calculation

Perfect! 🙂