Yearly ESCALATION calculation

[DMManalili]

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

excel: should be amount

[anirudh]

Try

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

Regards,
Anirudh

[DMManalili]

hi anirudh,

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

[anirudh · Accepted solution]

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

[DMManalili]

yes it works,, thank you 🙂

[anirudh]

Perfect! 🙂