Function Index

MovingMin

Find the minimum value within a moving window.

Usage

MovingMin(<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

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