MAX

The MAX function returns the maximum value from a series of number, date, time, or text values.

Syntax:
MAX (series-item-expression)
Meaning:
MAX (series_of_which_to_find_max)
Returns:
A single number

The result is the maximum value in the input argument series: number, text, or date/time.

Examples

  • MAX ( UnitPrice:Input )

    If the values for UnitPrice are {20, 10, 100}, MAX returns 100.

  • MAX(EXTRACT( DueDate:Book:Library, CheckedOut:Book:Library = "Y"))

    Returns the maximum (latest) DueDate for a book that is checked out from the library.

Related functions

  • MIN