Computes the largest integer that is not more than the input value. Input can be an Integer, a Decimal, a column reference, or an expression. 

Numeric literal example:

derive type:single value: FLOOR(2.5)

Output: Generates a column with each row's value 2.

Expression example:

derive type:single value: FLOOR(MyValue + 2.5)

Output: Generates a column containing the largest integer that is less than the sum of 2.5 and the value in the MyValue column.

derive type:single value: FLOOR(numeric_value)

ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column or Decimal or Integer literal to apply to the function


Name of the column, numeric literal, or numeric expression.

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal2.5

Example - Exponential functions