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
excel: should be amount
Tagged:
0
Best 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,
Anirudh1
Comments

Try
PREVIOUS('Calc Yearly Amount  Cumulate) * 1.1
This will work only if the line item item is dimensioned by Year timescale
Regards,
Anirudh0 
hi anirudh,
its the same figure i got. please see ss below. thank you
0 
yes it works,, thank you 🙂0

Perfect! 🙂1