## Count items in a flat list?

Occasional Contributor

## 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?

1 ACCEPTED SOLUTION

Accepted Solutions
Regular Contributor

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.

6 REPLIES 6
Regular Contributor

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.

Occasional Contributor

Thanks! That worked. I was overthinking it.

Contributor

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

Frequent Contributor

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

Note: flat list cannot be a part of hierarchy.

Thanks.

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

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 .