Skip to main content

NULLIFZERO

Returns a set of scalar values where Zero values are substituted with NULL.

Syntax​

NULLIFZERO(member_set, [member_property])

Input parameters​

member_set​

Required. An MDX expression that represents a set of dimension members.

member_property​

Optional. The intrinsic member property used to generate the scalar value. Supported values:

  • 'name': Refers to the MDX intrinsic property 'name'.
  • 'key': Refers to the MDX intrinsic property 'key'.

If no value is specified, member_property defaults to 'name'.

Example​

The following expression returns the count of scalar values returned for the level alias [Customer].[f_order_count].[f_order_count], generated using the 'name' property:

COUNT(NULLIFZERO([Customer].[f_order_count].[f_order_count].members, 'name'))