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