How to get a count in Anaplan?

Highlighted

How to get a count in Anaplan?

OPI #Mgr 1. OPI #Mgr2. OPI #Mgr3. OPI #Mgr4. OPI #Count
8116293381433252181161
901482933814332521901481
995272933814332521995271
37417029338143325213741701
37606029338143325213760601
38755629338143325213875561
325212933814332521 7
9144629338143389387914461
141746293381433893871417461
275678293381433893872756781
338122293381433893873381221
351413293381433893873514131
375917293381433893873759171
382607293381433893873826071
391712293381433893873917121
391756293381433893873917561
38938729338143389387 10
814329338143  18

 

in the above flat file, i want to get a count for first column data. for example in the first column, how many times "8116" present in the sheet ? count from column 2nd column till Mgr4 column. in this example "8116" present only once but "32521" present 7 times. I can achieve this in excel. How can i achieve this in Anaplan? Can any one please help me?

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: How to get a count in Anaplan?

ganesh.ramasubramonian@enquero.com 

 

See if this helps

 

First create a list of OPIs in your model and and then use that list as a dimension in your module. Create other line items as OPI list formatted line items. Use SUM & LOOKUP in your Result Line items to get the desired count on any of these columns.

Note: Don't use SUM & LOOKUP together as there are performance issues.

 

 

 

Highlighted
Frequent Contributor

Re: How to get a count in Anaplan?

Hi Ganesh,

 

1. Create a list which has all the OPIs.

2. Use FINDITEM for each column to find whether that OPI is present in that column or not.

  FI_1= FINDITEM( OPIs, Mgr 1. OPI # ) , FI_2 = FINDITEM( OPIs, Mgr 2. OPI # )....

3. Create another line item, say Count and write 1.

4. create another line item and Sum count based on finditem.  -> Count[SUM: FI_1] + Count[SUM: FI_2]...

 

this should work. let me know.

 

Thanks,

Harsha

 

Highlighted

Re: How to get a count in Anaplan?

Thanks Harsha, It works 👍