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 |