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?
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.
Thanks! That worked. I was overthinking it.
if the flat list don't have top level item, how it will calculate?
hey @Javvaji45 , if you see at the screenshot there is top level item present.
Note: flat list cannot be a part of hierarchy.
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 .
Hi @Javvaji45 can you explain how to calculate count of items in flat list without top level
@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
Thank you @Javvaji45 it worked :)