fbpx

Divide (MDX)

Performs a division returning the alternate value if the denominator is 0 or Empty

Parameters

Name Type Cardinality Default value
numerator  expression  one   
denominator  expression  one   
alternateresult  expression  zero-one  NULL 

Return

value

Description

The Divide function returns the division value ( numerator / denominator ). If the denominator is a
0, Empty or NULL value the function will return the alternate result.

See Also

Iif

Examples

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.