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

Accepted answers

anirudh

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

All comments

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

DMManalili

yes it works,, thank you 🙂

anirudh

Perfect! 🙂

Quick Links

Can you help?

Unanswered questions

Dynamic Export Reporting
Hi All, I want to address an query related to exports, In Output model, which is read access for all users & roles.user want to have dynamic export depending on user selection of multiple regions. So for selected regions , they will be able to see the data only for selected regions. Thanks,
1.5.2 activity: import data into beginning inventory
Kindly assist me to load data into the model.
Support error
Hello , Facing an error in looging in support portal , can anyone assist