INT
Description:
The MDX Int function returns the next lowest integer value of an expression.
Syntax:
INT(Numeric_Expression)
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Numeric_Expression | Numeric expression to apply the mathematical operation to. |
Example:
WITH MEMBER [Measures].[Integer Sales] AS
Int([Measures].[Internet Sales Amount])
SELECT
{[Measures].[Internet Sales Amount], [Measures].[Integer Sales]} ON COLUMNS,
[Product].[Product Categories].[Category].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]