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
