Syntax

Mod ( numeric_value_expr_1, numeric_value_expr_2 )

Parameters

numeric_value_expr_1

The number for which to find the remainder. Must be a numeric value or an expression that returns a numeric value (see MDX Grammar Rules).

numeric_value_expr_2

The divisor. Must be a numeric value or an expression that returns a numeric value (see MDX Grammar Rules).

Notes

The Essbase implementation of the function Mod returns the following values, which may be different from other vendors' implementations:

Mod(n,k) = - Mod(-n,k) , where n < 0
Mod(n,k) =  Mod(n,-k) , where k < 0

Example

The following MDX query:

WITH MEMBER [Measures].[Factor] AS 
 'Mod ([Measures].[Margin %],[Measures].[Profit %])'
SELECT
 {
  [Measures].[Margin %],
  [Measures].[Profit %], 
  [Measures].[Factor]
 }
ON COLUMNS, 
 {[Year].[Qtr1].Children}
ON ROWS
FROM sample.basic

returns the following output: