The ROUND() function rounds a numeric value to the desired number of decimal places.
The precision parameter is optional. Precision can be negative to round to the left of the decimal point (tens, hundreds, etc.).
Numeric function name:
ROUND()
Syntax
ROUND(value, precision)ℹ 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. |
precision |
(optional) Number of decimal places to keep. By default (rounded to the nearest integer). Can be negative to round to the left of the decimal point (tens, hundreds, etc.). |
Example
ROUND(3.14159, 2)Result: 3.14
ROUND(37.2)Result: 37
ROUND(1234, -2)Result: 1200
Notes
- ROUND() rounds to the nearest value at the requested precision (≥ 5 rounds up, < 5 rounds down).
- The precision parameter is optional: if omitted, the value is automatically rounded to the nearest integer.
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.