Advice how to structure rolling forecast formula with time element
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!