RUNNINGSUM( )
Calculates a running sum for each data row. A running sum is a total accumulated from row to row.
Syntax
RUNNINGSUM(expr)
Argument
expr
The expression specifying the values to use in the calculation. The data type must be numeric.
Returns
A cumulative total for each row.
Example
The following example calculates a running sum for each value in the LineItemTotal. For example, if the LineItemTotal field contains 50, 75, 80, 90, and 95, RUNNINGSUM( ) returns 50, 125, 205, 295, and 390 for each row, respectively.
RUNNINGSUM([LineItemTotal])