1. Calculation functions
  2. All Functions
  3. Numeric Functions
  4. MAX

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

Back to Top

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:

Back to Top

Similar functions