Count in numbered list

Hello everyone,

I am facing a problem in counting the same names in numbered list. Let me explain with pictures,

I have a numbered list :- Style. In this list, every member has different code but multiple members has the same Display name property as shown in the picture below.

Screenshot 2022-06-14 at 10.44.17 AM.png

I have a module "Module M1", where this list is used as dimension and I have two line items, 1. Boolean1, 2. Count.

Screenshot 2022-06-14 at 10.44.02 AM.png

Boolean1 is true for many styles which have same name but I want to count them as only 1 if they have same name as shown in the picture "Actual Count". I have tried firstoccurrence formula but it ignores the styles if its first occurrence in the list doesn't have Boolean1 - true. I have tried RANK formula in two other line items like one with sequential rank and other with minimum rank, compared them but it didn't work. These two line item didn't show the same values so that I can compare them and use IF ELSE statement.

Have a look at this problem and share your solution. Your help will be much appreciated.

Thanks!

Shubham

Accepted answers

ManjunathKN

Hi @ShubhamCh

Let me know if this helps you.

Thanks,
Manjunath

All comments

Pooja

Hi Shubham,

I think the below solution will work.

Create one list for display name called "Style Type"

Let me know if you need any clarification.

Thanks

Pooja

sobaid

I am getting all the values as 1 for the rank logic

ShubhamCh

@Pooja

Hi Pooja,

I think this solution can work but in the given example there are only 4-5 style names but the model that I am working on has 30000+ styles. Roughly, there would be 10000 unique style display names. How do you suggest to create this new list? Also, currently the boolean1 has a formula which is applicable on style list. Would it work with a different list as it is working now?

- Shubham

ShubhamCh

@Pooja

Also try unchecking first Style 1 and Style 2. I think the formula won't work.

ManjunathKN

Hi @ShubhamCh

Let me know if this helps you.

Thanks,
Manjunath

rob_marshall

@ShubhamCh

@Pooja was on the correct track, create a flat list of all Styles using the code (10,000 will not be too many). On the transaction list, set the Display Name property to the above Style flatlist. Create a module (TRANS Module), using the transactional list (Trans List), create a line item named Count? with the formula isfirstoccurrence(Trans List.Display Name, Trans List). Create another line item named Actual Count with the formula, if count? then 1 else 0. Create another module dimensionalized by Styles Flat, with a line item called Total with the formula: Trans Module.Count[sum:Trans List.Display Name].

Rob

ShubhamCh

@ManjunathKN

Thanks Manjunath! Yours was the easiest method to solve this problem.👍

Thanks @Pooja @rob_marshall for helping me. Kudos to you too😊.

- Shubham

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…