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 |