| Oracle® OLAP Expression Syntax Reference Release 11.2 Part Number E23381-01 | 
 | 
| 
 | PDF · Mobi · ePub | 
ROUND returns a number rounded to a specified number of places.
NUMBER
ROUND(n [, integer ])
n is the number to round.
integer is the number of decimal places of the rounded number. A negative value rounds to the left of the decimal point. The default value is 0.
ROUND(15.193) returns the value 15.
ROUND(15.193,1) returns the value 15.2.
ROUND(15.193,-1) returns the value 20.