Share via

  • Article

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