# 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.