ELCOMPN returns the number of elements of the consolidation.
Where can the ELCOMPN function be used?
Excel, Rules and TurboIntegrator
What is the ELCOMPN function?
ELCOMPN returns the number of elements of the consolidation.
What is the syntax for ELCOMPN?
ELCOMPN(dimension, element)
Dimension = A dimension name.
Element = The name of a consolidated element.
A demonstration on how to use ELCOMPN
Use ELCOMPN function to determine the number of elements of the consolidation and apply it in the rule to populate in the Product Scorecard cube.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book