Hub
Pricing About
WorkflowWorkflow

Inventory Cover

InventoryStockCover
alexanderfillbrunn profile image
Draft Latest edits on 
Nov 23, 2022 1:41 PM
Drag & drop
Like
Download workflow
Workflow preview
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
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 4.5.2
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.5.2

    knime
  • Go to item
    KNIME Math Expression (JEP)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.5.0

    knime
  • Go to item
    KNIME Timeseries nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.5.0

    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits