COUNT
Use the COUNT function to count the number of items in a Text
, Number
or Choice
array that are numbers. Numbers are actual numbers, like 12
or 102
or text that contains only numbers, such as "123"
or "99.99"
.
Use
COUNT( array )
Counts how many numbers are in the array.
Parameter | Required | Description |
---|---|---|
array | Yes | a text, number or choice array |
Returns | Number |
Use with literals
COUNT({1, 2, 3})
returns 3
COUNT({"1", "2", "hello"})
returns 2
Use with fields
COUNT(@inp.ClaimAmounts)
if input field @inp.ClaimAmounts contains 4 items but one is blank, returns 3