Skip to content

PARENTCOUNT

Returns the number of parent elements in a hierarchy.

js
PARENTCOUNT(dimension, hierarchy, element)
PARENTCOUNT(dimension, hierarchy, element)

Parameters

  • dimension - The dimension in which the selected hierarchy exists.
  • hierarchy - The identifier of the hierarchy to search.
  • element - The identifier of the child element.

Examples

js
PARENTCOUNT("Account", "Management Profit and Loss", "Revenue")
PARENTCOUNT("Account", "Management Profit and Loss", "Revenue")