CumulativeAvg

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.

See Also

• Avg
• MovingAvg