Truncates the input value to the specified number of digits or decimal places
Category: math
Syntax:
Trunc([number], [digits])
Number
Context Filtering: ✓ Yes
Parameters
| Name | Type | Required | Description |
|---|
number | number or column | ✓ Yes | The number to be truncated |
digits | number | ✗ No | The number of decimal places to which to round. Defaults to 0 |
number: INT, FLOAT, DECIMAL
Validation
- Minimum parameters: 1
- Maximum parameters: 2
Examples
Truncates the value in each row of the Cost column to 3 decimal places
Returns 5.24
Result: 5.24
Returns 5
Result: 5 Last modified on March 13, 2026
