How to get a count in Anaplan?

gramasub
gramasub
in 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:

Best Answer

  • Harsha
    Harsha
    Answer ✓

    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

     

Answers

  • Misbah
    Misbah

    @gramasub 

     

    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.

     

     

     

  • gramasub
    gramasub

    Thanks Harsha, It works 👍

Categories