Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference MAX
Functions and Expressions Reference Guide
149
MAX
The MAX function returns the maximum value from a series.
Syntax
MAX (series-item-expression)
Meaning
MAX (series_of_which_to_find_max)
Returns
This function returns a single-number.
The result is the maximum value in the input argument series: number, text,
or date/time.
Example
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.
Uses
Use
MAX to find the maximum value in a series of number, date, time, or text
values.
Related Function
MIN