MovingAvg

Calculates the numerical average in a moving window.

Usage

MovingAvg(numbers, average, below)

numbers (required) The column of numbers to average.

above (required) The number of rows above the current to include.

below (optional) The number of rows below the current to include. Defaults to 0.

Example

MovingAvg([Population 2010], 4, 0)
  • For each value in [Population 2010] and the 4 values above it, calculate the average.

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us