AddN (MDX+)

Returns the sum of all parameters, empty if ANY of the parameters is empty or null.

Parameters

Name	Type	Cardinality	Default value
	numeric-expression	one-n

Return

numeric-value

Description

This functions sums all parameters values, if any of them is null or empty it will return empty.

AddN(A,B, ... ) = A + B + ... ; empty if any of the parameters is null

Note, this function - in opposition to MinusN,DivN and PercN - does NOT use the third parameter as a CoalesceEmpty shortcut.

Examples

AddN(A,B)

addN
7

AddN(A,B) - empty case

Returns empty if one of the parameters is empty

Query

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

Result

addN

addN

Assertion : MDX Equals

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

Assertion : MDX Equals

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

Since Version

4.7

XMLA Properties

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