icCube

Documentation

CoalesceEmpty

(MDX)

Returns the first non-empty numeric value from the parameters list.

Parameters

Name Type Cardinality Default value
  numeric-expression  one-n   

Return

numeric-value

Description

The function returns the first non-empty/null numeric value among the list of parameters.

Usually used to handle nulls, division by zero and/or add a default numeric value.

See Also

CoalesceNull Iif

Examples

Special Examples (errors, null, ...)

XMLA Properties

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