Skip to main content
Returns the largest value amongst the inputs Category: math Syntax: 
Greatest([input1], [input2], ...)
Returns: Any Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
input1number or date or string or column✓ YesThe data or column of data to be evaluated. Input can be numbers, dates, or strings
inputsnumber or date or string or column✗ NoAdditional inputs to compare. All additional inputs must match the type of the first input
Allowed Column Types for input1: INT, FLOAT, DECIMAL, DATE, DATETIME, VARCHAR, TEXT Allowed Column Types for inputs: INT, FLOAT, DECIMAL, DATE, DATETIME, VARCHAR, TEXT

​
Validation

  • Minimum parameters: 2
  • Maximum parameters: 10

​
Examples

Greatest([Profit 2020], [Profit 2021], [Profit 2022])
Returns the profit from the year with the greatest profit 
Greatest(10, 20, 5, 15)
Returns 20 Result: 20 
Greatest([Invoice Date], Date("2020-01-01"))
Returns the more recent date
Last modified on March 13, 2026