CumulativeAvg

The CumulativeAvg function calculates the numerical average of the input column up to and including the current value.

Syntax

CumulativeAvg(\[Column\])

Function Arguments:

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

πŸ“˜

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

Example

CumulativeAvg(\[Monthly Revenue\])

A table contains the monthly revenue of a store.Β  The CumulativeAvg function can be used to find the average up to and including the current value.


Related resources