Counting # of Elements in a Subset

Post Reply
KevinB
Posts: 13
Joined: Tue Jun 02, 2009 8:03 pm
Version: 9.1.4
Excel Version: 2007

Counting # of Elements in a Subset

Post by KevinB »

Hello All!

Does anyone have a quick method or function that returns the number of elements in a subset?

Thanks!

~Kevin
Top
Wim Gielis
MVP
Posts: 3230
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:
Contact Wim Gielis

Re: Counting # of Elements in a Subset

Post by Wim Gielis »

Hello Kevin

In a worksheet, you would use the function SUBSIZ.

In a TI process, you would use the function SUBSETGETSIZE.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Top
KevinB
Posts: 13
Joined: Tue Jun 02, 2009 8:03 pm
Version: 9.1.4
Excel Version: 2007

Re: Counting # of Elements in a Subset

Post by KevinB »

Wim,

Wow.. Too easy.

Thanks for your help!

~Kevin
Top
Post Reply

Return to “IBM TM1, Planning Analytics, PAx and PAW”