नोट
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप साइन इन करने या निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
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)