Int

The MDX Int function for Essbase returns the next lowest integer value of an expression.

Syntax

Int ( numeric_value_expression )

Parameters

numeric_value_expression

A numeric value or an expression that returns a numeric value (see MDX Grammar Rules).

Example

Example 1

Int(104.504) returns 104.

Example 2

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:

Table 4-83 Output Grid from MDX Example

(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