2 Replies Latest reply on Nov 1, 2017 7:42 AM by Peirce Law

    Removing Duplicates - Exact entry matches

    Peirce Law

      The datamart I use can sometimes create a few duplicates and I have a few duplicate entries.

       

      I would use a distinct count but I'm also trying to get a sum of sales from the reference numbers so it's combining the sales from each entry.

      I already know the correct count but the sums is aggregating all of the entries.

       

      The normal LOD Calc method won't work because every field is identical between them.

       

      Thanks!