1 of 1

Count

The Count() function returns the number of items in a list or concept set.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

Returns the number of items in the given list or concept_set.

Returns Unknown if one of the parameter values is unknown or outside the common valid boundaries.

Count(list)

Count(List("A", "B", "C"))=>Result: 3

Count([Products] where [Product.Price] > 10)=>Result: returns the number of products that cost more than 10 euro

Count()=>Result: unknown

Count(concept_set)

Count({ Color.Orange, Color.Blue, Color.Red })=>Result: 3

Count(unknownconceptset)=>Result: unknown

Name

Type

Required

Description