The following section describes the syntax and usage of the COUNT function in ActivityInfo.
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.
COUNT(val1, val2, ...)
|...||No||Any further values.
If an argument is missing or NA, it will be excluded from the calculation.
The count of all defined values found in the input set.
We will be using the COUNT function to calculate the number of defined row values from a set of three columns.
We will be using three Quantity fields:
- "Value 1" (with code "val1")
- "Value 2" (with code "val2")
- "Value 3" (with code "val3")