MIN

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

Description

The MIN function is used to find the lowest value from a set of values. 

Syntax

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

Example

We will be using the MIN function to find the lowest 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

MIN(val1,val2,val3)

Results