CumSum / Computation Layer
Calculate the running sum of values in a column. Similar to pandas cumsum() or running total in SQL.
For each position i:
Applications:
- Running totals
- Progressive summation
- Accumulated values
Note: Ignores null values. Direction controlled by Reverse
parameter.
Table
0
0
Table
Transforms
[, ...]Select
columnThe column (Select
) for cumulative sum. Example with [1, 2, 3, 4]:
- Forward: [1, 3, 6, 10]
- Reverse: [10, 9, 7, 4]
Reverse
boolControls summation direction:
- false: sum from top to bottom
- true: sum from bottom to top
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn
matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.