Remainder

Returns the fractional part of the numeric value expression.

Syntax

Remainder ( numeric_value_expression )

numeric_value_expression A numeric value expression.

Example

Remainder([Margin %]) 
extracts the fractional part of the [Margin %] value.

The following 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

This query returns the following grid:

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

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com