This workflow demonstrates the usage of a recursive loop for inventory cover calculation.
The algorithm calculates the cover for an inventory. For each week, we have end inventory and consumption and calculate the number of weeks the end inventory lasts.
We do this by going through the table row by row and each time:
- We check if it is the last row. If yes, we return 0.
- Otherwise, we take the cumulative sum of the consumption in the following weeks and
- count the number of weeks the inventory lasts.
- If at the end a fraction is left, we calculate that as well as (end inventory - consumption until then) / consumption of next week
Used extensions & nodes
Created with KNIME Analytics Platform version 4.5.2
Legal
By using or downloading the workflow, you agree to our terms and conditions.