How to add prior year data value

Hi,

I have a line item Headcount and my current year is FY17.

For FY18 I need headcount value to be prior year headcount and FY19 to be FY18+FY17 headcount value.

Can I please get some guidance.

Regards

Madhu

Tags

Modeling

Calculation Functions

Accepted answers

All comments

You'll need two line items - one to enter/hold the headcount change, and one with a formula to maintain a running balance over time - use the PREVIOUS function to access the last value and add the change. You might also want to look into opening/closing balances.

Quick Links

Can you help?

Unanswered questions

403 error trying to access Support Portal
Hi - can't access support portal having already registered. Receive the following error message - is this an issue with Anaplan or our internal IT?
Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…