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).

Examples

MinusN(A,B)

minusN
-1

minusN(A,B) - empty case

Returns empty if one of the parameters is empty

Query

WITH
    MEMBER [minusN] AS MinusN( ([Amount],[Geography].[Spain]) , ([Amount],[Geography].[France],[Time].[2011]) )
SELECT
    [minusN] ON 0
FROM
    [Sales]

Result

minusN

minusN

Assertion : MDX Equals

WITH
    MEMBER [minusN] AS NULL
SELECT
    [minusN] ON 0
FROM
    [Sales]

Assertion : MDX Equals

WITH
    MEMBER [minusN] AS minusN( ([Amount],[Geography].[Spain]) , NULL )
SELECT
    [minusN] ON 0
FROM
    [Sales]

MinusN(A,B,0.0) - empty case with third parameter

minusN
0.0

Since Version

4.7

XMLA Properties

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