ROUND (Report Builder)

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

Syntax

ROUND(number, digits)

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

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)

Help and Information

Getting SQL Server 2005 Assistance