Compounding Growth In Forecast Model
Composing a typical growth forecast. I am having an issue when my raw data ends. (FY23 is the last year). Then once I get into my forecast years, the lag function (and previous function) have nothing to pull from (zero value).
LAG(Research Allocation Rate (Original), 1, 0) * (1+Growth Rate). So essentially for FY24, I recieve a value with growth, but all items past FY24 are blank. I feel like there is a simple solution, but been at this for awhile.
I essentially need it to take the previous years actual cell value instead of recalcing every time thus compounding the growth across time.
I have the growth rate by year in a seperate module.
Thanks in advance,