1 2 Previous Next 17 Replies Latest reply on Sep 12, 2019 8:30 AM by Ashfaque Shaikh

    Duplicate values

    Abdul A

      Hi, I have below data and would like to see if I can avoid duplicate  while calculating.  here in below table when I am trying to use IIF([Purchased]="Y",1,0) then I am getting for ABC  count  as 2, but I wanted to display only once since it has Y.  Please help me fixing this.

       

      CompanyPurchased
      ABCY
      DEFN
      ABCY
      GEFY
      STRY
        1 2 Previous Next