How do I move one value to the next month?

I have a calculation currently in the "Usage Base Forecast" line item. I want it so that if a user checks off the "Use Previous Month Final Forecast", it moves the final forecast from last month to next month. For example, if the boolean is checked off for July, it will take the "Usage Final Base Forecast" and move it to August. I'm thinking that I need a POST or OFFSET formula?

Carry Fwd Adj.JPG

Accepted answers

All comments

ChrisStauffer

zdlee,

Not sure what else you have going on that module but yes you can use an offset -1 to pull the prior period forward one period conditionalized on the boolean.

Post is a push forward whereas offset is a pull forward. Post is only used with numbers, offset can be used with all data formats. Post takes more computational power than Offset.

https://community.anaplan.com/t5/On-Demand-Courses/POST-vs-OFFSET/ta-p/133941

Also download out this awesome Functions model that shows you how all the functions work.

https://community.anaplan.com/t5/learning/Anaplan-Formulas-and-Functions/ba-p/28081

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…