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