COUNT (Report Builder)
Returns the number of non-null items within a set.
Syntax
COUNT(aggregate)
aggregate |
Specifies the field name or expression to aggregate. |
Remarks
- Null values are ignored.
Examples
| Formula | Result |
|---|---|
COUNT(Employee) |
Counts the number of employees in the Employee field to return a single value such as 97. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Aggregate Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)