/ (Divide) (MDX)
Performs an arithmetic operation that divides one number by another number.
Syntax
Dividend / Divisor
Parameters
- Dividend
A valid Multidimensional Expressions (MDX) expression that returns a numeric value.
- Divisor
A valid MDX expression that returns a numeric value.
Return Value
A value with the data type of the parameter that has the higher precedence.
Remarks
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.
Examples
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])