The FLOOR() function rounds a number down, returning the nearest integer less than or equal to the number.
Numeric function name:
FLOOR()
Syntax
FLOOR(value)ℹ Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to be added between quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
value |
Number to round down. |
Example
FLOOR(4.3)Result: 4
FLOOR(7.5)Result: 7
FLOOR(-2.1)Result: -3
Return type
The function returns a number.
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.