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