CumulativeCount

The CumulativeCount function counts the number of non-null values of a column, up and including the current row value.

Syntax

CumulativeCount(\[Column\])

Function Arguments:

• [Column] (required) - A column of text, numbers or dates to count the number of non-null values up to and including the current row value.

Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.

Example

CumulativeCount(\[Number of Violations\])

A table contains data for restaurant inspections by day.  The CumulativeCount function can be used to count the amount of days with at least one violation up to and including the current day.