How to fill a line item recursively
I have one module where one of the line items is my inventory amount and on the columns I have a list where I put diferent fiscal years (note that I cannot use the formula PREVIOUS() because this module is not connected with Time, and I can't connect it either).
So my list is composed by: FY22, FY23, FY24, FY25, FY26, FY27, FY28
The module has the line item "Inventory amount" and "Inventory increase" with the FY list as columns.
The idea is that FY22 is an input, but from FY23 to the end of the FY list it should be a calc doind the inventory amount from last year times the inventory increase on FY23.
How can I do that?
Print as example, FY24 being calculated with amount from FY23 and increase from FY24: