Icon

max cumulative 5

Find, for each project, the highest ROWINDEX containing anon-zero estimate, and likewise for non-zero budget calculatecummulativesumsstart loopon projectend loopDataRow index containing non-zero estimateRow index containing non-zero budgetGroup by projectGet "high water marks"for each projectSet zero estimates to nullbeyond "high water mark"Set zero budgets to nullbeyond "high water mark"tidy up Moving Aggregation Group Loop Start Loop End Table Creator Rule Engine Rule Engine GroupBy Joiner Rule Engine Rule Engine Column Filter Find, for each project, the highest ROWINDEX containing anon-zero estimate, and likewise for non-zero budget calculatecummulativesumsstart loopon projectend loopDataRow index containing non-zero estimateRow index containing non-zero budgetGroup by projectGet "high water marks"for each projectSet zero estimates to nullbeyond "high water mark"Set zero budgets to nullbeyond "high water mark"tidy up Moving Aggregation Group Loop Start Loop End Table Creator Rule Engine Rule Engine GroupBy Joiner Rule Engine Rule Engine Column Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: z0036jba
Created at: 2021-04-30
On NodePit since: 2022-02-06
Last update: 2024-11-21
Created with KNIME version: v4.3.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!