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
© 2024 Altair Engineering Inc. All Rights Reserved.