Tips and Tricks 

Returns the number of numerical values in a set of mixed data types. Any non-numerical values are ignored in the count.

Usage:

CountNumber( r )

Parameters:

r

Reference to a question in a repeating page, repeating section or multiple row data source.

Example:

The following example counts any employees in a set of data who have been assigned an agreement number. Some employees do not have an assigned number, so any blank or non-numeric values are not counted.

CountNumber([q6.EmployeeAgreementNumber])
 

Related Articles

 

Keywords

Format Formula Design Count Number