Map and Table Calculation

CUM( ) function

Returns the cumulative sum of a ValueColumn, or
returns the cumulative sum of a ValueColumn according to a certain sort order.

Syntax

CUM(ValueColumn)
CUM(ValueColumn, SortColumn)

Input

ValueColumn	is a value column
Domain type:	any Value domain
SortColumn	is a column on which you wish to sort before calculating the cumulative sum

Output

CUM returns:	a value
Domain:	system domain Value

Note:

When a value in the input column is undefined, the record is excluded from the calculation.

Tips:

If you choose to sort on a column during a cumulative sum, it is a good idea to sort the table on that column as well: choose Sort from the Columns menu.
To calculate the sum of a column or the sum per group of a column, see the AGGSUM function. You can also use the SUM function to calculate the sum of a column.
When the definition symbol = is used, a dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output column has been calculated.

Usable in

Examples

TabCalc example:

OutCol1 = CUM(InCol)
OutCol2 = CUM(InColA, InColB)