The INT() function returns the integer part of a number by rounding it down. It differs from simple rounding for negative numbers.
Numeric function name:
INT()
Syntax
INT(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 for which you want to obtain the integer less than or equal to it. |
Example
INT(3.7)Result: 3
INT(-3.7)Result: -4
Notes
INT()always rounds down: for negative numbers, the result is smaller than the original number.
Return type
The function returns an integer.
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.