Home > Working with Planning Projects > Building an Application > Building Application Models > Building A Cube Model > Measure Settings > Measure Logic Functions > INT function
INT function
Last Updated 8/26/2008 1:05 PM
The INT function will truncate a number to an integer or to a number of decimal places.
Format: INT(VALUE,[NO_DECIMAL_PLACES])
where
VALUE is the number to be truncated.
NO_DECIMAL_PLACES is an optional argument and is a number specifying how many decimal places to allow before truncation. Note that a negative number will replace digits to the left of the decimal point.
EXAMPLE:
Assume the measure 'Expenses' has a value of 2378.6799.
INT('Expenses')
returns a value of 2378.00.
INT('Expenses', 0)
also returns a value of 2378.00.
INT('Expenses', 1)
returns a value of 2378.60.
INT('Expenses', -1)
returns a value of 2370.00.
See Also
PREVIOUS function
SUM function
MAX function
MIN function
DEPRECIATION function
ROUND function
ROUNDUP function
ROUNDDOWN function
IF Function
SWITCH Function
| 
Page URL: