Maths functions

MIN – Select miniumum value

46 views June 1, 2018 admin 0

Overview

Returns the minimum of the arguments.

Syntax

MIN (n1, n2, n3)

MIN(10,15,25)

n1, n2, n3 List of numerical values or arguments. Can have as many values/arguments as required.

Examples

MIN(FIELDVAL(‘Price’),10)

Price MIN
5.00 5.00
10.00 10.00
15.00 10.00
17.50 10.00

In the example above MIN(FIELDVAL(‘Price’),10) looks at each value in the Price field and compares it to 10 and returns the minimum value. In row 1, the price is 5.00, which is lower than 10 so ‘5.00‘ is returned. In row 3, the price is 15.00, which is higher than 10 so ‘10.00‘ is returned.

MIN(FIELDVAL(‘Price’),10,17)

Price MIN
5.00 5.00
10.00 10.00
15.00 10.00
17.50 10.00

In the example above MIN(FIELDVAL(‘Price’),10,17) looks at each value in the Price field and compares it to 10 and 17 and returns the minimum value. In row 1, the price is 5.00, which is lower than 10 or 17 so ‘5.00‘ is returned. In row 3, the price is 15.00, which is higher than 10 but lower than 17 so ‘10.00‘ is returned.

See also

MAX

AVG

MOD

MUL

DIV

Was this helpful?