GreatestNonNull

Returns the greatest value from two or more values with matching data types, ignoring Null values.

Syntax

GreatestNonNull(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.

Notes

• If all inputs are Null, returns Null.
• To compare two values of different data types, convert one of the values to match the data type of the other using the appropriate type conversion function. For example, you can convert a string to a number using the Number function, or to a date using the Date function.

Example

GreatestNonNull(Null, 2, 3)

• Returns 3.

GreatestNonNull(Null, -2, -4)

• Returns -2.

GreatestNonNull(0, [Airline Delay])

• In a calculated column, returns the greater of 0 or the value in the Airline Delay column for each row. If Airline Delay is Null, returns 0.