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.

// Ethnio survey code removed