CumulativeSum

The CumulativeSum function calculates the sum of the input column up to and including the current row value.

Syntax

CumulativeSum(\[Column\])

Function Arguments:

  • [Column] (required) - The column of numbers to evaluate the cumulative sum.

Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.

Example

CumulativeSum(\[Monthly Revenue\])

A table contains the monthly revenue of a store for the year 2022. The CumulativeSumย function can be used to find the total yearly revenue up to and including that month.ย 


Related resources