Edit

Share via


COUNT ER function

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

The COUNT function returns an Integer value that represents the number of records in the specified list, if the list isn't empty. If the list is empty, this function returns 0 (zero).

Syntax

COUNT (list)

Arguments

list: Record list

The valid path of a data source of the Record list data type.

Return values

Integer

The resulting numeric value.

Example

COUNT (SPLIT("abcd" , 3)) returns 2, because the SPLIT function that is used in this example creates a list that consists of two records.

Additional resources

List functions