CoalesceEmpty

Return to: Calculated Member Builder Function List

Coalesces an empty cell value to a number or a string and returns the coalesced value.

Syntax

CoalesceEmpty(«Value Expression»[, «Value Expression»]...)

Remarks

Returns the first (from the left) non-empty value expression in the list of value expressions. Returns the empty cell value if all value expressions evaluate to the empty cell value.

All value expressions must evaluate to the same type, numeric or string, or to the empty cell value.

For more information about empty cells, see the OLE DB documentation.

Example

To string:

CoalesceEmpty(Time.Parent.Name, "EMPTY")

Returns “EMPTY” if Time.Parent.Name is the empty cell value, Time.Parent.Name otherwise.

To number:

CoalesceEmpty(Measures.CurrentMember, -99)

Returns -99 if Measures.CurrentMember is the empty cell value, Measures.CurrentMember otherwise.