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:
-
#DIRECT
-
#ALL
-
#DETAILS
-
-
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