Advice how to structure rolling forecast formula with time element

Options
ChristinePowell
ChristinePowell Member, ALL USERS Posts: 1 New Contributor

Hey-

I am looking to build on a formula in my rolling forecast. I am having trouble laying out the necessary steps.

 

Percentage Seasonality: Each period in a year (12) has an assigned rate. When I roll my forecast, I need the percentage to take the current forecast month rate / the sum of the remaining forecast periods' rates.

 

Any insight would be helpful. Thanks!