AVERAGE
The following section describes the syntax and usage of the AVERAGE function in ActivityInfo.
Description
The AVERAGE function is used to find the average or mean of a set of values.
Syntax
AVERAGE(val1, val2, ...)
| Argument | Required | Description |
|---|---|---|
| val1 | Yes | A numeric value. |
| val2 | Yes | Another numeric value. |
| ... | No | Any further numeric values. If an argument is missing, NA, or non-numeric, it will be excluded from the calculation. |
Result
The numeric average of the set of input arguments.
Example
We will be using the AVERAGE function to calculate the average row value of 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
AVERAGE(val1,val2,val3)
Results
