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?
Answers
-
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
0
