Skip to main content
Returns the smallest value amongst the inputs Category: math Syntax: 
Least([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

Least([Price1], [Price2], [Price3])
Returns the smallest price among three columns 
Least(10, 20, 5, 15)
Returns 5 Result: 5 
Least([Invoice Date], Date("2020-01-01"))
Returns the earlier date
Last modified on March 13, 2026