How to get children count of consolidated element?

Post Reply
Ashleigh W
Posts: 63
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

How to get children count of consolidated element?

Post by Ashleigh W » Wed Sep 26, 2018 6:00 am

Is there a formula to get children count of consolidated element within excel/tm1 perspective function?

User avatar
Alan Kirk
Site Admin
Posts: 5839
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: How to get children count of consolidated element?

Post by Alan Kirk » Wed Sep 26, 2018 6:03 am

Ashleigh W wrote:
Wed Sep 26, 2018 6:00 am
Is there a formula to get children count of consolidated element within excel/tm1 perspective function?
ElCompN, assuming that you are talking about children and not descendants.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

Ashleigh W
Posts: 63
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Re: How to get children count of consolidated element?

Post by Ashleigh W » Wed Sep 26, 2018 6:33 am

perfect! thank you.

Post Reply