How to get a count in Anaplan?

Options
gramasub
gramasub Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 2 New Contributor
in Planning & Modeling
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?

Tagged:

Comments

  • Harsha
    Harsha Member, ALL USERS, GroupMember, Partner, Certified Master Anaplanner Posts: 5 Certified Master Anaplanner

    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

     

  • gramasub
    gramasub Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 2 New Contributor

    Thanks Harsha, It works 👍

Categories