Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Number functions > Truncate function |
|
|
| Truncate function |
| Format |
Truncate(number;precision) |
| Parameters |
| number - any numeric expression or field containing a numeric expression |
| precision - any numeric expression or field containing a numeric expression |
| Data type returned |
| number |
| Description |
| Returns number truncated to the specified precision (number of decimal places), without evaluating the value of discarded digits. Use the Round function to round up or down to the required precision. |
| Examples |
| Truncate(123.456;2) returns 123.45. |
| Truncate(-14.6;0) returns -14. |
| Truncate(29343.98;-3) returns 29000. |
| Truncate(123.456;4) returns 123.456. |
| Truncate(29343.98;5) returns 29343.98. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Number functions > Truncate function |
|
|
Next Page |
|