Home > Working with Planning Projects > Building an Application > Building Application Models > Building A Cube Model > Measure Settings > Measure Logic Functions > ROUND function
ROUND function
Last Updated 8/26/2008 1:05 PM
The ROUND function will round a number of the specified number of decimal places.
Format: ROUND(VALUE, NO_DECIMAL_PLACES)
where
VALUE is the number to be rounded.
NO_DECIMAL_PLACES is a number specifying how many decimal places to round to. Note that a negative number will round numbers to the left of the decimal point.
EXAMPLE:
Assume the measure 'EXPENSES' has a value of 2378.6799
ROUND('EXPENSES', 0)
returns a value of 2379.00
ROUND('EXPENSES', 1)
returns a value of 2378.70
ROUND('EXPENSES', -1)
returns a value of 2380.00
See Also
PREVIOUS function
SUM function
MAX function
MIN function
DEPRECIATION function
INT function
ROUNDUP function
ROUNDDOWN function
IF Function
SWITCH Function
| 
Page URL: