Returns the next lowest integer value of an expression.
Int ( numeric_value_expression )
| numeric_value_expression | A numeric value or an expression that returns a numeric value. |
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:
| 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 |
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |