3 Replies Latest reply: May 25, 2012 5:04 AM by Animesh Bag RSS

    Count of Distinct Records

      Dear Experts,

       

      Kindly help me regarding the Following

       

       

       

      PO No
      PR NO
      RFQ NO
      Expression
      1010110114000
      2020120113000
      30301
      2000
      40
      30115000

       

      I am having a Pivot Table of the above type

       

      I am making another Chart in which I am counting No.POs, No of PRs and No of RFQs

       

      I am using following script =count (distinct (FIELD NAME)),

       

      Result should be PO = 4 PR = 3 RFQ  = 3

       

      BUT I am getting result PO= 4 PR = 4 RFQ = 4

       

      I think it is counting the blank field also

       

      Kindly help on this

       

      Thanks and Regards,

      Animesh