Skip to main content

ZEROIFNULL

Returns a set of scalar values with NULL values substituted with ZERO.

Syntax​

Form 1​

ZEROIFNULL(member_set, [member_property])

Form 2​

ZEROIFNULL(scalar)

Input parameters​

Form 1​

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: The MDX intrinsic property name.
  • key: The MDX intrinsic property key.

If no value is specified, defaults to name.

Form 2​

scalar​

Required. A numeric scalar, such as a metric or calculation value, or a numeric constant.

Examples​

Form 1​

MAX(ZEROIFNULL({ [Customer].[Number of Cars Owned].[Number of Cars Owned].Members }, 'name'))
COUNT(ZEROIFNULL({ [Customer].[Number of Cars Owned].[Number of Cars Owned].Members }, 'key'))

Form 2​

ZEROIFNULL([Measures].[Reseller Sales Amount Local]) / [Measures].[Internet Sales Amount Local]