Product documentation
What’s new
- Release Notes
- Documentation Updates
Starting with Journey Orchestration
Configuring an event
Configuring a data source
Configuring an action
Using segments
Building a journey
Build expressions
- Overview
- Syntax
- Functions
  - Main Functions
  - Adobe Experience Platform
    - inSegment
  - Aggregation
    - avg
    - count
    - countOnlyNull
    - countWithNull
    - distinctCount
    - distinctCountWithNull
    - max
    - min
    - sum
  - Conversion
    - toBool
    - toDateOnly
    - toDateTime
    - toDateTimeOnly
    - toDecimal
    - toDuration
    - toInteger
    - toString
  - Date
  - List
    - distinct
    - distinctWithNull
    - filter
    - getListItem
    - in
    - intersect
    - limit
    - listSize
    - serializeList
    - sort
  - Math
    - random
    - round
  - String
    - concat
    - contain
    - containIgnoreCase
    - endWith
    - endWithIgnorecase
    - equalIgnoreCase
    - indexOf
    - isEmpty
    - isNotEmpty
    - lastIndexOf
    - length
    - lower
    - matchRegExp
    - notequalIgnoreCase
    - replace
    - replaceAll
    - split
    - startWith
    - startWithIgnoreCase
    - substr
    - trim
    - upper
    - uuid
Building your reports
Integrating with Intelligent Services
- About AI integration
- Leveraging Customer AI
Use cases
Working with APIs

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.

Business.Adobe.com resources

Campaign Reporting Email Reporting Triggered Emails Offer Management Email Creation Dynamic Content

On this page

View next: