Remainder

The MDX Remainder() function for Essbase returns the fractional part of the numeric value expression.

Syntax

Remainder ( numeric_value_expression )

Parameters

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

Example

Remainder([Margin %])

extracts the fractional part of the [Margin %] value.

The following MDX query shows [Margin %] and the fractional part of it for all members of the Product dimension.

WITH
   MEMBER [Measures].[Margin % Rem] AS 'Remainder([Margin %])'
SELECT
   {[Margin %], [Margin % Rem]} ON COLUMNS,
   [Product].Members ON ROWS
FROM Sample.Basic

The above query returns the following grid:

Table 4-123 Output Grid from MDX Example

(axis)	Margin %	Margin % Rem
Product	55.262	0.262
100	57.273	0.273
100-10	61.483	0.483
100-20	51.479	0.479
100-30	50.424	0.424
200	55.540	0.540
200-10	54.270	0.270
200-20	56.436	0.436
200-30	56.450	0.450
200-40	55.753	0.753
300	54.238	0.238
300-10	55.816	0.816
300-20	42.992	0.992
300-30	57.551	0.551
400	53.600	0.600
400-10	57.354	0.354
400-20	56.299	0.299
400-30	39.477	0.477
Diet	55.397	0.397
100-20	51.479	0.479
200-20	56.436	0.436
300-30	57.551	0.551