Afternoon, 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, Evan
... View more