Home > Working with Planning Projects > Building an Application > Building Application Models > Building A Cube Model > Measure Settings > Measure Logic Functions > ROUNDDOWN function
ROUNDDOWN function
Last Updated 8/26/2008 1:06 PM
The ROUNDDOWN function will round a number downwards to the specified number of decimal places.
Format: ROUNDDOWN(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 2389.5678.
ROUNDDOWN('EXPENSES', 0)
returns a value of 2389.0000.
ROUNDDOWN('EXPENSES',1)
returns a value of 2389.5000.
ROUNDDOWN('EXPENSES',-1)
returns a value of 2380.00.
See Also
PREVIOUS function
SUM function
MAX function
MIN function
DEPRECIATION function
INT function
ROUND function
ROUNDUP function
IF Function
SWITCH Function
| 
Page URL: