Floor function

Returns the largest integer greater than or equal to the numeric value in each cell of a column. For example, if the value is 2.21, FLOOR  returns 2. If the value is 5.88, FLOOR returns 5. Likewise, if the value is -5.15, FLOOR returns -6.

Namespaces

• math

Input

Non-decimal numeric values

Output

Double values

Syntax

set-column :column math:floor(column)

Example

Returns largest integer greater than or equal to the numeric value in each cell in the test column.

set-column :test math:floor(test)