Function Index

MovingMax

Find the maximum value within a moving window.

Usage

MovingMax(<field>,<above>,<below>)

field (required) The column to be searched.

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.

Examples

MovingMax([Population 2010], 5, 5)
  • Calculate the maximum population for each set of 11 adjacent values.