TRUNC (Report Builder 1.0)
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 |