Returns the fractional part of the numeric value expression.
Remainder ( numeric_value_expression )
numeric_value_expression | A numeric value expression. |
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 |