distinctCountWithNull

Last update: 2021-10-27
  • Created for:
  • Experienced
    Developer

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.

On this page