topic Re: How to get a count in Anaplan? in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/How-to-get-a-count-in-Anaplan/m-p/77698#M16379
<P>Thanks Harsha, It works <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span></P>Wed, 22 Jul 2020 05:25:20 GMTganesh.ramasubramonian@enquero.com2020-07-22T05:25:20ZHow to get a count in Anaplan?
https://community.anaplan.com/t5/Anaplan-Platform/How-to-get-a-count-in-Anaplan/m-p/77689#M16371
<TABLE width="562"><TBODY><TR><TD width="64">OPI #</TD><TD width="107">Mgr 1. OPI #</TD><TD width="107">Mgr2. OPI #</TD><TD width="107">Mgr3. OPI #</TD><TD width="113">Mgr4. OPI #</TD><TD width="64">Count</TD></TR><TR><TD>8116</TD><TD>2933</TD><TD>8143</TD><TD>32521</TD><TD>8116</TD><TD>1</TD></TR><TR><TD>90148</TD><TD>2933</TD><TD>8143</TD><TD>32521</TD><TD>90148</TD><TD>1</TD></TR><TR><TD>99527</TD><TD>2933</TD><TD>8143</TD><TD>32521</TD><TD>99527</TD><TD>1</TD></TR><TR><TD>374170</TD><TD>2933</TD><TD>8143</TD><TD>32521</TD><TD>374170</TD><TD>1</TD></TR><TR><TD>376060</TD><TD>2933</TD><TD>8143</TD><TD>32521</TD><TD>376060</TD><TD>1</TD></TR><TR><TD>387556</TD><TD>2933</TD><TD>8143</TD><TD>32521</TD><TD>387556</TD><TD>1</TD></TR><TR><TD>32521</TD><TD>2933</TD><TD>8143</TD><TD>32521</TD><TD> </TD><TD>7</TD></TR><TR><TD>91446</TD><TD>2933</TD><TD>8143</TD><TD>389387</TD><TD>91446</TD><TD>1</TD></TR><TR><TD>141746</TD><TD>2933</TD><TD>8143</TD><TD>389387</TD><TD>141746</TD><TD>1</TD></TR><TR><TD>275678</TD><TD>2933</TD><TD>8143</TD><TD>389387</TD><TD>275678</TD><TD>1</TD></TR><TR><TD>338122</TD><TD>2933</TD><TD>8143</TD><TD>389387</TD><TD>338122</TD><TD>1</TD></TR><TR><TD>351413</TD><TD>2933</TD><TD>8143</TD><TD>389387</TD><TD>351413</TD><TD>1</TD></TR><TR><TD>375917</TD><TD>2933</TD><TD>8143</TD><TD>389387</TD><TD>375917</TD><TD>1</TD></TR><TR><TD>382607</TD><TD>2933</TD><TD>8143</TD><TD>389387</TD><TD>382607</TD><TD>1</TD></TR><TR><TD>391712</TD><TD>2933</TD><TD>8143</TD><TD>389387</TD><TD>391712</TD><TD>1</TD></TR><TR><TD>391756</TD><TD>2933</TD><TD>8143</TD><TD>389387</TD><TD>391756</TD><TD>1</TD></TR><TR><TD>389387</TD><TD>2933</TD><TD>8143</TD><TD>389387</TD><TD> </TD><TD>10</TD></TR><TR><TD>8143</TD><TD>2933</TD><TD>8143</TD><TD> </TD><TD> </TD><TD>18</TD></TR></TBODY></TABLE><P> </P><P>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?</P>Wed, 22 Jul 2020 03:49:44 GMThttps://community.anaplan.com/t5/Anaplan-Platform/How-to-get-a-count-in-Anaplan/m-p/77689#M16371ganesh.ramasubramonian@enquero.com2020-07-22T03:49:44ZRe: How to get a count in Anaplan?
https://community.anaplan.com/t5/Anaplan-Platform/How-to-get-a-count-in-Anaplan/m-p/77693#M16374
<P><LI-USER uid="23020"></LI-USER> </P><P> </P><P>See if this helps</P><P> </P><P>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.</P><P><STRONG>Note: Don't use SUM & LOOKUP together as there are performance issues.</STRONG></P><P> </P><P> </P><P> </P>Wed, 22 Jul 2020 04:36:09 GMThttps://community.anaplan.com/t5/Anaplan-Platform/How-to-get-a-count-in-Anaplan/m-p/77693#M16374Misbah2020-07-22T04:36:09ZRe: How to get a count in Anaplan?
https://community.anaplan.com/t5/Anaplan-Platform/How-to-get-a-count-in-Anaplan/m-p/77696#M16377
<P>Hi Ganesh,</P><P> </P><P>1. Create a list which has all the OPIs.</P><P>2. Use FINDITEM for each column to find whether that OPI is present in that column or not.</P><P> FI_1= FINDITEM( OPIs, <SPAN>Mgr 1. OPI # ) , FI_2 = FINDITEM( OPIs, Mgr 2. OPI # )....</SPAN></P><P><SPAN>3. Create another line item, say <STRONG>Count </STRONG>and write 1.</SPAN></P><P><SPAN>4. create another line item and Sum count based on finditem. -> Count[SUM: FI_1] + Count[SUM: FI_2]...</SPAN></P><P> </P><P><SPAN>this should work. let me know.</SPAN></P><P> </P><P><SPAN>Thanks,</SPAN></P><P><SPAN>Harsha</SPAN></P><P> </P>Wed, 22 Jul 2020 05:18:42 GMThttps://community.anaplan.com/t5/Anaplan-Platform/How-to-get-a-count-in-Anaplan/m-p/77696#M16377Harsha2020-07-22T05:18:42ZRe: How to get a count in Anaplan?
https://community.anaplan.com/t5/Anaplan-Platform/How-to-get-a-count-in-Anaplan/m-p/77698#M16379
<P>Thanks Harsha, It works <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span></P>Wed, 22 Jul 2020 05:25:20 GMThttps://community.anaplan.com/t5/Anaplan-Platform/How-to-get-a-count-in-Anaplan/m-p/77698#M16379ganesh.ramasubramonian@enquero.com2020-07-22T05:25:20Z