@MAX

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, Oracle recommends using 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