Min

Returns the minimum value of the non-null elements of the given set of numbers.

Syntax

Min(n1 [, n2 ...])

Parameters

Parameter

Description

n1

A numeric value or expression.

n2 (optional)

Additional numeric values and/or expressions.

Note: FormCalc follows the IEEE-754 international standard when handling floating point numeric values. For more information, see Number literals.

Examples

The following expressions are examples of using the Min function:

Expression

Returns

Min(234, 15, 107)

15

Min("abc", 15, "Tony Blue")

15

Min("abc")

0

Min(Field1[*], Field2[0])

Evaluates the non-null occurrences of Sales_July as well as the first occurrence ofSales_August, and returns the lowest value.

Min(Max(Field1[*], Field2[0]), Field3, Field4)

The first expression evaluates the non-null occurrences of Field1 as well as the first occurrence ofField2, and returns the highest value. The final result is the minimum of the returned value compared against the values of Field3 and Field4.

See also Max.

// Ethnio survey code removed