Function Index

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.

Examples

CumulativeAvg([Profits])
  • For each value in [Profits], calculate the average of that value and everything before it.