Returns the largest value amongst the inputs.
Greatest(<input 1>, <input 2>…)
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.
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.
More About Math Functions
These functions return well-known mathematical constants or implement common arithmetic functions.