Returns the maximum value among the results of the expressions in the specified member list.
@MAX (expList)
expList | Comma-delimited list of members, variable names, functions, and numeric expressions, all of which return numeric values. |
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.
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
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |