Show Menu
TOPICS×

count

Counts the elements of the list not taking into account the null values.

Category

Aggregation

Function syntax

count(<listAny>)

Parameters

Parameter
Type
List
listString
List
listBoolean
List
listInteger
List
listDecimal
List
listDuration
List
listDateTime
List
listDateTimeOnly

Signatures and returned type

count(<listAny>)
Returns an integer.

Example

count([10,2,10,null])
Returns 3.