@MAX
The @MAX calculation function for Essbase returns the maximum from a list of numeric values.
Syntax
This function returns the maximum value among the results of the expressions in expList.
@MAX (expList)
Parameters
Notes
Depending on the values in the list, this function may return zero(0) or #MISSING
. For full control over skipping or inclusion of empty values, use @MAXS instead.
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