DocumentationJourney OptimizerJourney Optimizer Guide

distinctCountWithNull distinctCountWithNull

Last update: Mon Jan 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Experienced
  • Developer

Counts the number of different values including the null values.

Note that the parameter <listObject> is not supported in this function.

Category

Aggregation

Function syntax

distinctCountWithNull(<listAny>)

Parameters

Parameter
Type
listToProcess
listString, listBoolean, listInteger, listDecimal, listDuration, listDateTime, listDateTimeOnly, listDateOnly

Signature and returned type

distinctCountWithNull(<listAny>)

Returns an integer.

Example

distinctCountWithNull([10,2,10,null])

Returns 3.

recommendation-more-help
b22c9c5d-9208-48f4-b874-1cefb8df4d76