DocumentationJourney OrchestrationJourney Orchestration

distinctCountWithNull distinctCountWithNull

Last update: Wed Oct 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)

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.

recommendation-more-help
4f4a00c1-77c9-4eee-84df-bbe6206c3ab9