Returns the maximum value among the results of the expressions in the
specified member list.
Syntax
@MAX (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, @MAX 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 @MAXS function
instead of the @MAX function.
Example
This example is based on the Sample Basic database:
Qtr1 = @MAX(Jan:Mar);
This example produces the following report:
Colas New York Actual
Jan Feb Mar Qtr1
=== === === ====
Sales 678 645 675 678
See Also
- @MAXS
- @MAXSRANGE
- @MINS