Returns the minimum value among the results of the expressions in expList.
Syntax
@MIN (expList)
Parameter | Description |
---|---|
expList | Comma-delimited list of members, variable names, functions, and numeric expressions, all of which return numeric values. |
Notes
Depending on the values in the list, @MIN may return a zero(0) or #MISSING value. For full control over skipping or inclusion of zero(0) and #MISSING values, it is recommended to use the @MINS function instead of the @MIN function.
Example
In the Sample Basic database:
Qtr1 = @MIN(Jan:Mar);
produces the following report:
Colas New York Actual Jan Feb Mar Qtr1 === === === ==== Sales 678 645 675 645
See Also