icCube

Documentation

MinusN

(MDX+)

Returns the first parameter minus the second one, empty if ANY of the parameters is empty or null.

Parameters

Name Type Cardinality Default value
  numeric-expression  one   
  numeric-expression  one   
  numeric-expression  zero-one   

Return

numeric-value

Description

This functions returns the first parameter minus the second one, if any of them is null or empty it will return empty.

MinusN(A,B) = A - B ; empty if A or B are null/empty

It will return the third parameter instead of null if the third parameter is defined (like a CoalesceEmpty).

See Also

AddN DivN PercN CoalesceEmpty

Examples

Since Version

4.7

XMLA Properties

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