Home > Working with Planning Projects > Building an Application > Building Application Models > Building A Cube Model > Measure Settings > Measure Logic Functions > MAX function
MAX function
Last Updated 8/26/2008 1:04 PM
The MAX function returns the maximum of two or more measures.
Format: MAX('MEASURE1', 'MEASURE2', ['MEASURE3'...'MEASURE(n)'])
where:
MEASURE 1 is the first measure.
MEASURE 2 is the second measure.
MEASURE 3 is the third measure.
...
MEASURE(n) is the nth measure.
EXAMPLE:
Assume you wish to find the maximum of two measures.
'Salaries'
'Marketing'
'Maximum Expense' = MAX('Salaries', 'Marketing')
returns the maximum of Salaries and Marketing to each column.
Or if you wish to find the maximum of several expense items.
'Salaries'
'Marketing'
'Training'
'Office Admin'
'Total Expense' = MAX('Salaries', 'Marketing', 'Training', 'Office Admin')
returns the maximum of Salaries, Marketing, Traning and Office Admin to each column.
You can substitute a value for one of the parameters.
'Weeks'
'Weeks per month' = MAX ('Weeks', 4)
returns the maximum of weeks and the value 4 to each column.
See Also
PREVIOUS function
SUM function
MIN function
DEPRECIATION function
INT function
ROUND function
ROUNDUP function
ROUNDDOWN function
IF Function
SWITCH Function
| 
Page URL: