Sdílet prostřednictvím

  • Článek

ROUND (Report Builder 1.0)

Rounds a number to a specified number of digits from the decimal point.

Syntax

ROUND(number, digits)

number

Indicates the number to be rounded.

digits

Specifies the number of digits from the decimal point to which the number is rounded.

Remarks

  • If the number of digits is greater than 0 (zero), then the number is rounded to the specified number of decimal places.

  • If the number of digits is 0, then the number is rounded to the nearest integer.

  • If the number is less than 0, then the number is rounded to the left of the decimal point.

  • Report Builder rounds down if the number to the right is between 0 and 4 and rounds up if the number is between 5 and 9.

Example

Formula

Result

ROUND(168.375, 2)

168.38

ROUND(168.375, 0)

168

ROUND(168.375, -2)

200