Dear community.
I have an excel file that helps me solve a problem on different rows and different columns process.
It´s an inventory balance that is running for every period. I get the information of demand per period, Inventory in the first period, and the fixed amount that can be supplied in the week that the inventory starts in 0 or less.
I am trying to know how the inventory will run for all the periods and in which periods will I have to supply.
It´s an easy topic to solve in excel, but I am struggling a lot to solve it in Alteryx.
Any suggestions on how to complete the table for all the periods? I have attached the excel file as well. Thank you very much!
