MovingCount

Count values in a moving window. Null values are not counted.

Usage

MovingCount(field, above, below)

field (required) The column of numbers, text, or dates to count. Null values are skipped.

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

MovingCount([Population 2010], 5, 5)
  • Count the number of non-null values in a 11 row window.

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us