COUNT
The following section describes the syntax and usage of the COUNT function in ActivityInfo.
Description
The COUNT function is used to count all defined values in a set of values. If a value is not defined or empty, then it is not included in the count.
Syntax
COUNT(val1, val2, ...)
| Argument | Required | Description |
|---|---|---|
| val1 | Yes | A value. |
| val2 | No | Another value. |
| ... | No | Any further values. If an argument is missing or NA, it will be excluded from the calculation. |
Result
The count of all defined values found in the input set.
Example
We will be using the COUNT function to calculate the number of defined row values from a set of three columns.
Arguments
We will be using three Quantity fields:
- "Value 1" (with code "val1")
- "Value 2" (with code "val2")
- "Value 3" (with code "val3")
Formula
COUNT(val1,val2,val3)
Results
