TRUNC (Report Builder)
Truncates a number to the number of digits specified.
Syntax
TRUNC(number, digits)
number |
Indicates the number to be truncated. |
digits |
Specifies the number of digits from the decimal point to which the number is truncated. |
Remarks
- If the number is positive, the number is truncated to the right of the decimal.
- If the number is negative, the number is truncated to the left of the decimal.
Example
| Formula | Result |
|---|---|
TRUNC(495.1275, 3) |
495.127 |
TRUNC(495.1275, -2) |
400 |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Math Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Numerical Data (Report Builder)