Icon

Sumif - sammeredith

Create dataGroup Loop based on Cost ElementKeep month >= 1Keep month >=4Groupby Cost Element; sum over ValueMake 1 rowDivide Value from month 4by sum of values for months 1-4Keep rowswhere percentis between24 and 27Compile rowsRemoveunnecessary columnsTable Creator Group Loop Start Row Filter Row Filter GroupBy Column Appender Math Formula Row Splitter Loop End Column Filter Create dataGroup Loop based on Cost ElementKeep month >= 1Keep month >=4Groupby Cost Element; sum over ValueMake 1 rowDivide Value from month 4by sum of values for months 1-4Keep rowswhere percentis between24 and 27Compile rowsRemoveunnecessary columnsTable Creator Group Loop Start Row Filter Row Filter GroupBy Column Appender Math Formula Row Splitter Loop End 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: Loïc
Created at: 2021-02-25
On NodePit since: 2021-02-25
Last update: 2024-05-02
Created with KNIME version: v4.3.1

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

Try NodePit Runner!