0 Replies Latest reply: Jan 16, 2018 7:56 AM by Parco Tam RSS

    count if with like and equal as condition on a separate table

    Parco Tam

      I am trying to use the data from the top table to create the bottom table. For example, "ID" 1 and "FIELD_ID" "A0001" can be found in  column D formula 3 times for "ID" = 1. It will output "COUNT_FORMULA" of 3. This excludes the ones with "ID" 2.

       

      I first tried to separate (not joined) "COMPONENTS" in one table to lookup "CALCULATED" in another table.  It should match the ID and do something like a count on wildmatch/like for FIELD_ID in FORMULA.  However, I wasn't able to find the right syntax to do so.

       

      Note is that something like row 5 is counted once each for row 17 and row 18 since it has both A0002 and A0001.

       

      Thank you!

       

       

      ?ui=2&ik=999a97852c&view=fimg&th=160fe8f524a10d53&attid=0.1.1&disp=emb&realattid=img_5A5DD6DD029F014A003902FE_1@bloomberg.net&attbid=ANGjdJ-qgVpBq7db-i2TiFfA2MvQ08mzJKGbpRW7OMwUpQNGoFf7Xw45c_LTskGxQ_-iyJSmkKAkS0XGIZTc4wbApMpY6B22oVycuAiqpv2UHQvqwDYe2waxy8gaLsk&sz=s0-l75-ft&ats=1516104763580&rm=160fe8f524a10d53&zw&atsh=1