
Hello, everyone,
I'm trying to put together the formula to display the appropriate Unit Increase by & Total Unit Value outputs in the table above. The logic should go thus:
The 2% growth for FY23 should use the 100 unit value from FY22 as its base. The formula would go thus: (2% of 100)
The 5% growth for FY24 should use the Total Unit Value outcome from the FY23 calculation as its base. The formula would go thus: (5% of 102)
The 4% growth for FY25 should use the Total Unit Value outcome from the FY24 calculation as its base. The formula would go thus: (4% of 107).
.... and so on
FYI, FY23 - FY26 is a time range in the Model. Also, they are included as line items in a Time Lookups Module

I would apprepriate your perspective on how I should approach this.
Thank you.