distinctCountWithNull
Counts the number of different values including the null values.
Category
Aggregation
Function syntax
distinctCountWithNull(<listAny>)
Parameters
Parameter
Type
List
listString
List
listBoolean
List
listInteger
List
listDecimal
List
listDuration
List
listDateTime
List
listDateTimeOnly
List
listDateOnly
Signature and returned type
distinctCountWithNull(<listAny>)
Returns an integer.
Example
distinctCountWithNull([10,2,10,null])
Returns 3.
recommendation-more-help
4f4a00c1-77c9-4eee-84df-bbe6206c3ab9