Function: Min

Description

This function returns the smaller of expr1, expr2 and optionally an arbitrary number of additional parameters. All parameters must be of the same type: numeric, date or character.

Syntax

Min(expr1,expr2[,...])

Arguments

expr can be a constant, a numeric field, a character field, a date field or an expression. Note: In the case of a character field, x would be smaller than z.

Return value

This function returns the smaller of expr1, expr2 and optionally an arbitrary number of additional parameters. Accepts numeric, date or character input. Note: In the case of a character field, x would be smaller than z.

Calculated field example

If the Projected field contained the value 1000000 and the Actual field contained the value 40000, the following calculated field expression would return the value 40000: Min(Projected,Actual)

Filter/Find example

Records with Projected and Actual values both greater than or equal to 50000 can be selected or found using the expression: Min(Projected,Actual)>=50000

This expression is equivalent to the compound expression: Projected>=50000.And.Actual>=50000