Sum the values in a moving window.


MovingSum(number field, above, below)

number field (required) The column of numbers to be summed.

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.


MovingSum([Population 2010], 10)
  • Calculate the total for each row and the 10 above it.

See Also