Returns the next lowest integer value of an expression.
Syntax
Int ( numeric_value_expression )
Parameter | Description |
---|---|
numeric_value_expression | A numeric value or an expression that returns a numeric value (see MDX Grammar Rules). |
Example
Int(104.504) returns 104.
The following query
WITH MEMBER [Market].[West_approx] AS 'Int( Sum( Children([Market].[West]) ) )' SELECT {[Year].[Qtr1].Children} ON COLUMNS, {[Market].[West].children, [Market].[West_approx]} ON ROWS FROM Sample.Basic WHERE ([Measures].[Profit %], [Product].[Cola], [Scenario].[Actual])
returns the grid:
(axis) | Jan | Feb | Mar |
---|---|---|---|
California | 38.643 | 37.984 | 38.370 |
Oregon | 17.500 | 16.129 | 16.107 |
Washington | 29.231 | 30.986 | 32.000 |
Utah | 23.077 | 23.077 | 20.968 |
Nevada | -3.947 | -6.757 | -5.333 |
West_approx | 104.000 | 101.00 | 102.000 |