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.