Is there a node that allows computing the cumulative sum of another column up until each row? For instance if the source column contains the values 1,2,0,7,3,… the resulting column would contain the values 1,3,3,10,13,… I think some solutions are suggested in this topic , which all rely on scripting. It is also suggested that KNIME 2.10 would present an easier solution. We are now at 4.4. Has this been realized? Thanks in advance for suggestions, Wilfred

Hello @wvdvegte , and welcome to KNIME Community! Yes there is node to compute cumulative sum: [image] Moving Aggregator This node calculates aggregation values for a moving window. The aggregation values are displayed in new columns appended at the end of the table. The columns … In case you do it on a group level check this topic: [image] Cumulative sum with a condition KNIME Analytics Platform Hi @tomekk ! Don’t get discouraged! It can be pretty simple with KNIME. Like this: [GroupCumulativeSum] In case I haven’t missed something of course slight_smile And don’t hold it against @armingrudd and @mlauber71 . They like KNIME nodes so much they can’t get enough of it smiley Now you can use some rule based node to see which invoice exceeded a certain project sum wink 2019_01_23_Group_Cumulative_Sum.knwf (15.8 KB) Have a nice day, Ivan Br, Ivan

Creating a column with the cumulative sum of values in another column. Possible without scripting?

KNIME Analytics Platform

ipazin September 1, 2021, 1:29pm 2

Hello @wvdvegte,

and welcome to KNIME Community!

Yes there is node to compute cumulative sum:

In case you do it on a group level check this topic:

Br,
Ivan

5 Likes

Calculate max. tim in row for timetable

Stop my loop if the column sum is greater than 50% of my flow variable