4 Replies Latest reply on May 29, 2017 5:38 PM by Suneesh Sunny

    Data duplication

    Suneesh Sunny

      G'day,

                I am trying to perform an analysis where I have unique product serial numbers with sale prices. These products might have undergone multiple failures causing multiple warranty claims. When I am trying to join the sale machine sales & warranty data, the machine sales table were duplicated ( for the reason that there are mutliple failures against certain serial numbers) causing to give the wrong total sales value.

       

      What am trying to achieve is an accurate warranty to sales ratio, can somebody help?