Calculates the numerical average of the column up to and including the current value.
Usage
CumulativeAvg(field)
field (required) A column of numbers to evaluate.
NOTE: Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.
Example
CumulativeAvg([Profits])
- For each value in [Profits], calculate the average of that value and everything before it.