3 Replies Latest reply on May 10, 2017 9:52 AM by Ross Moffitt

    Incorrect Sum - Best Calculation - Distinct Sum or LOD or Max() ?

    Ross Moffitt

      See attached picture.desired_output.JPG

       

      I am trying to find the best calculation to use, as my sum is not summing correctly because I have multiple databases.

       

      I have 3 different databases, and one database has multiple records for each product. I'm just trying to do a simple sum on Sale from Database B, but I am getting a duplicated sale number (up to 3 or 4 times) because Database C has multiple records. For each record it is summing the sales by the same amount.

       

      What should I change my sum to in order to just get a sum on each distinct product?

       

      Thanks!