MAX

The following section describes the syntax and usage of the MAX function in ActivityInfo.

Description

The MAX function is used to find the highest value from a set of values. 

Syntax

MAX(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 highest numeric value found in the set of input values.

Example

We will be using the MAX function to find the highest row value 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

MAX(val1,val2,val3)

Results