nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

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.

All comments

jnoone

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 :)

Quick Links

Can you help?

Unanswered questions

Connection Problem with Excel Add-In Series 4 - No Customer
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
explainability results is blank into model
Why in my model output is blank, after send explainability data.
How can I use the RANK function with composite hierarchies where parent items can't be concatenated?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…