Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
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])