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

column

The column (Select) for cumulative sum. Example with [1, 2, 3, 4]:

  • Forward: [1, 3, 6, 10]
  • Reverse: [10, 9, 7, 4]
false

Controls summation direction:

  • false: sum from top to bottom
  • true: sum from bottom to top

Name 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.