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