Count
Aggregation
Count(column)
Counts non-NULL values of the column (SQL COUNT(col)). Over zero rows it returns 0, not blank — SQL rules.
When to use it
Section titled “When to use it”- How many rows have a value — payments with a settlement date, leads with an email.
- Prefer
CountRowsfor plain how many rows, andCountDistinctfor how many unique.
Example
Section titled “Example”OrderLines := Count(Sales.OrderId)