3 Replies Latest reply: Sep 27, 2013 2:33 AM by Laura Miclescu RSS

    Count(Distinct()) with condition

      Hi!

       

      I want to use COUNT(DISTINCT()) to calculate the number of clients that bought a certain product. I am using this formula, but the numbers are weird, it's not correct.

       

      IF(CPRODUS='A19', COUNT(DISTINCT(CCLIENT)))

       

      What to i do wrong?