MIN ()

MIN(value [, value, ...])

API Version	2.7.27 and higher

Calculates the minimum value of a list of values

Note that this function will calculate the minimum value depending on the type of values received:

If all the parameters are numeric, then a numeric comparison will be done. For example, MIN(“001”, “0002”) will return “001”.
If any of the parameters is not numeric, then a string comparison will be performed. For example, MIN(“xxx“, “001”, “0002”) will return “0002”.

Input Parameters

Parameter	Type	Default	Required	Description

Parameter

Type

Default

Required

Description

value

Yes

The parameter can be repeated an indefinite number of times.

The function also admits passing an array of scalar values (Number or String) as parameter

Execution

Always. Calculated on-the-fly whenever an ITEM of a FORM is changed (by means of form_set_answer(), or when the FORM is opened

Examples

Formula	Description

Formula	Description
`MIN(12, 13, 10)`	Result = 10
`MIN(“001”, “0002”)`	Result = “001” Note that as all the values are numeric, a numeric comparison is done
`MIN(“001”, “0002”, “xxx”)`	Result = “0002” Note that as at least one parameter is not numeric, a string comparison is done
`MIN(19, [12, 6], 15)`	Result = 6