Hi,

I have to calculate the cumulative sum of a column until a specific value is reached.

Example:

In this example, the cumulative sum of column “Amount” has to be calculated for each group of “Invoice” until the cumulative sum is equal to the “Threshold Amount” of that Invoice. When I am using Moving aggregation node, I’m getting value as in the “Cumulative Sum” column, whereas the expected output is the “Expected Cumulative Sum” column.

Is there a way to accomplish this?

Thank you