Count items in a flat list?
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?
Best Answer
-
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.
1
Answers
-
Thanks! That worked. I was overthinking it.
0 -
if the flat list don't have top level item, how it will calculate?
0 -
hey @Javvaji45 , if you see at the screenshot there is top level item present.
Note: flat list cannot be a part of hierarchy.
Thanks.
0 -
I understood the use case , but I'm asking how we calculate with out top level item - count of list items0
-
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 .
0 -
Hi @Javvaji45 can you explain how to calculate count of items in flat list without top level
0 -
@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
1 -
Thank you @Javvaji45 it worked :)
0
