COUNTDISTINCT (Report Builder 1.0)
Returns the number of non-null unique instances of an item within a set.
Syntax
COUNTDISTINCT(aggregate)
aggregate |
Specifies the field name or expression to aggregate. |
Remarks
- Null values are ignored.
Examples
Formula |
Result |
---|---|
COUNTDISTINCT(City) |
Counts the number of unique values in the City field. |