How do I move one value to the next month?

Options
zdlee
zdlee Member, ALL USERS, Partner, Certified Model Builder Posts: 4 New Contributor

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