CHILDCOUNT

Syntax

CHILDCOUNT (Dimension, {#DIRECT/#ALL/#DETAILS, {Parent Member}})

Description

The CHILDCOUNT function returns the number of a Parent member's children. This function takes the following one required argument and two optional arguments:

  • Dimension: The dimension to use.

  • For the second optional argument, select from these predefined constants:

  • Parent Member: This is an optional argument.

    If you do not use this optional argument, the function applies to the member that is currently being evaluated.

Returns

The number of a parent member's children.

Example

CHILDCOUNT (Region, #DIRECT, [Region:All_regions])

Related Topics