DIVIDE
Description:
This function is used to perform division and returns alternate result or BLANK() on division by 0.
Syntax:
Divide (<numerator>, <denominator> [,<alternateresult>])
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
numerator | The dividend or number to divide. |
denominator | The divisor or number to divide by. |
alternateresult | This is an optional value. The value is returned when division by zero results in an error. When the value is not provided, the default value is BLANK(). |
Example:
With Member [Measures].[D] as [Measures].[Internet Freight Cost] / [Measures].[Customer Count]
SELECT [Measures].[D] ON 0,
[Product].[Product Categories].[Category].Members ON 1
FROM [AdventureWorksMF]