Count items in a flat list?

CommunityMember129223

Hello, 

 

I am trying to count how many items are in a list and display it in a module?

In the example below we have 3 items in the list. 

 

Does a function like this exist? 

 

 

 

jnoone

Create a system module (with #promotion flat as a dimension) with a line item called "count" and a formula of just "1".  Create a second module which is a "totals module" (without #promotion flat as a dimension).  In the totals module create a line item called count that directly references the system module (system module.count).  It should naturally grab the top level.  

CommunityMember129223

Thanks! That worked. I was overthinking it. 

Javvaji45

 if the flat list don't have top level item, how it will calculate? 

rishabh01

hey @Javvaji45 , if you see at the screenshot there is top level item present.

Note: flat list cannot be a part of hierarchy.

Thanks.

Javvaji45

I understood the use case , but I'm asking how we calculate with out top level item - count of list items

Javvaji45

I got the solution for the with out top level item , we can calculate the count of items in flat list , by using the Another dimension  based on the dimension we can calculate it .

 

SyedArbaz

Hi @Javvaji45 can you explain how to calculate count of items in flat list without top level

Javvaji45

@SyedArbaz create one more list and add the item like "Top level" , you can hard code this item in the flat list dimensioned module and write the sum formula in the target module. see the below screen shots

SyedArbaz

Thank you @Javvaji45 it worked :)