/ (Divide) (MDX)

Performs an arithmetic operation that divides one number by another number.


Dividend / Divisor

Dividend

A valid Multidimensional Expressions (MDX) expression that returns a numeric value.

Divisor

A valid MDX expression that returns a numeric value.

A value with the data type of the parameter that has the higher precedence.

The actual value returned by the / (Divide) operator represents the quotient of the first expression divided by the second expression.

Both expressions must be of the same data type, or one expression must be able to be implicitly converted to the data type of the other expression. If Divisor evaluates to a null value, the operator raises an error. If both Divisor and Dividend evaluate to a null value, the operator returns a null value.

The following example demonstrates the use of this operator.

-- This query returns the freight cost per user,
-- for products, averaged by month. 
With Member [Measures].[Freight Per Customer] as
 (
    ( [Measures].[Internet Freight Cost])
    / 
    [Measures].[Customer Count])
)

SELECT 
    [Ship Date].[Calendar Month of Year].Children ON 0,
    [Product].[Category].[Category].Members ON 1
FROM
    [Adventure Works]
WHERE
    ([Measures].[Freight Per Customer])

Community Additions

ADD
Show: