How to get children count of consolidated element?

Post Reply
Ashleigh W
Posts: 88
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 »

Is there a formula to get children count of consolidated element within excel/tm1 perspective function?
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: How to get children count of consolidated element?

Post by Alan Kirk »

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: 88
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 »

perfect! thank you.
Post Reply