MAX

Use MAX to insert the highest value in a group of objects, such as a group of measures. This function uses this syntax, in which arg1... represent the function that retrieves the values of the objects to use:

MAX(arg1, arg2...)

Assume these measure results

The measure whose formula you are creating (represented by this): 766
Car Sales=9000
Truck Sales=11000

This formula inserts 1100 since Truck Sales has the highest result value:

MAX(mResult(this),mResult(“Car sales”), mResult(“Truck sales”))

To use this function:

Select Functions, thenStatistical and double-click MAX.
This inserts MAX(arg1, arg2...)
Delete arg1 and insert the function that retrieves the values to use.
For example, to find the highest result collected by a measure, insert mResult.
Select the object to use from the box that is displayed.
Repeat steps 2 and 3 to specify the remaining arguments.