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 |