icCube

Documentation

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.

SumN(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.

See Also

MinusN DivN PercN

Examples

Since Version

4.7

XMLA Properties

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