3 Replies Latest reply on May 23, 2017 3:19 PM by Eva K

    sum of unique ids when there are duplicates in id column

    Eva K

      i have a sample data set with 4 columns, id1, id2, effectdate and amt.

      I want to get a sum of column amt for all the distinct id1.

      i tried using a lod but it's not working,

       

      for eg. id1 = 3 has 2 rows,    

       

      id1          id2          effectdate          amt

      3          1234          03/01/2017          90

      3          5462          03/01/2017          90

       

      so, when i take a sum of amt for id1, it should only show 90 and not 180. I am getting 180. In the same manner, i want to get a sum of the entire column amt for all the unique id1.