Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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)