Oracle® OLAP Expression Syntax Reference Release 11.2 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
.