knime inventory coverage in days

Hello everyone!

I’m trying to calculate the stock coverage, considering that I have the initial stock and another 200 columns with daily requirements, these columns with daily requirements have some that are zero.

the calculation is if the stock >= requirement 1, then the variable receives 1, if the stock is less than the requirement, then it remains (stock / requirement 1), and so the calculation must be carried out by decreasing the stock of all requirements until the zero stock, and the variable receives one for each time the stock becomes positive, another factor if the requirement is zero, then 1 must be considered in the variable.

I understand that there must be a loop to do this calculation, but I can’t do it.