Livecycle

Count

Evaluates a set of values and/or expressions and returns the count of non-null elements contained within the given set.

Syntax

Count(n1 [, n2 ...])

Parameters

 

Parameter	Description
n1	A numeric value or expression.
n2 (optional)	Additional numeric values and/or expressions.

Note:

FormCalc follows the IEEE-754 international standard when handling floating point numeric values. For more information, see “Number literals”.

Examples

The following expressions are examples of using the Count function:

 

Expression	Returns
Count(“Tony”, “Blue”, 41)	3
Count(Customers[*])	The number of non-null occurrences of Customers.
Count(Coverage[2], “Home”, “Auto”)	3, provided the third occurrence of Coverage is non-null.

Count