Greatest

Returns the largest value amongst the inputs.

Usage

Greatest(input1, \[input2\], ...)

input 1 (required) The data or column of data to be evaluated. Input can be numbers, dates, or strings.

input 2+ (optional) Additional inputs to compare. All additional inputs must match the type of the first input.

NOTE: If you would like to compare a column of dates against a specific date, you must wrap the input in the Date() function.

Example

Greatest(\[Profit 2018\], \[Profit 2017\], \[Profit 2016\])

• Returns the profit from the year with the greatest profit

Greatest(\[Invoice Date\], Date("2018-01-01"))

• Returns the more recent date.