The function takes two or more parameters and returns the maximum value: It can be used for numeric or date-formatted source line items. If used for date-formatted line items, it returns the most recent date.
It can also be used as an aggregation function, see x[MAX:y].
Syntax
MAX(x,y,[z])
where:
- x: Number or date to compare
- y: Number or date to compare
Format
| Input Format | Output Format |
|---|---|
|
x: number or date y: number or date |
Matches the data format used by argument x |
Arguments
The function uses the following arguments:
- x: number-formatted or date-formatted line items
- y: number-formatted or date-formatted line items
Constraints
The function has the following constraints:
- At least two arguments must be passed.
- The result formatting must match the source formatting.
Excel equivalent
Example
A number-formatted Maximum Monthly Costs result line item uses MAX against six number-formatted source line items:
A text-formatted Latest Accounting Date result line item uses MAX against three date-formatted source line items:
- A number-formatted Maximum Monthly Costs result line item uses MAX against six number-formatted source line items:
- A text-formatted Latest Accounting Date result line item uses MAX against three date-formatted source line items:
