6 Replies Latest reply: Sep 21, 2017 7:24 AM by Phalgun Parvathaneni RSS

    Percentages exceeding 100% when dividing by Count Total Distinct

    Phalgun Parvathaneni

      Hello, I have a data set as follows:

       

      Month

      MonthVendorDistinct ID Count
      JanA7451
      B6260
      C563
      FebA7260
      B6250
      C560
      MarA7128
      B6266
      C540
      AprA7138
      B6285
      C559

       

      Now I want to display the percentages of the distinct IDs per vendor for each month. For example: In January, Vendor A percentage is

      7451/(7451+6260+563)*100=52.199%. I'm using the following expression:

       

      Count(distinct(ID))/Count(distinct total <[Month]> (ID))*100

       

      But this expression is giving me the percentages as 62,52,5 sum of which is exceeding 100%. Can you please help me get my expression right? TIA!

      stalwar1