Cumulative Sum

Hi,
What would be the best way to get the cumulative sum of the Seconds Column based on the Group Column. (see sample data below). Please take note that the cumulative sum resets when followed by different group. Thanks!

image

Hi @mmrcs,
just for understanding. In your example the column group has 2 times the value 1. Are these data independent on from each other? If yes do you have other key columns there they differ?

BR

Hi @morpheus
Yes it occurred twice… they are independent from each other. I don’t have any other key columns where they differ, that’s why I’m having a hard time.

BR

1 Like

@mmrcs, I think I’ve solved it. I created the following workflow that will start a new running total/cumulative sum every time the group is different from the previous row.

Cumulative_Sum.knwf (28.3 KB)

Steve

4 Likes

Thanks for the help @stevelp
It really solves my problem!

BR

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.