3 Replies Latest reply: Dec 30, 2013 2:43 PM by Chuck Kindred RSS

    Set Analysis Sum Distinct

      I am trying to sum the difference between two date values for unique combinations of Name, Date1, and Date2

       

      I have data of the format:

       

      NameDate1Date2

      Chuck

      1/1/121/3/12
      Sam1/1/121/3/12
      Sam

      1/3/12

      1/5/12

      Sam

      1/3/121/5/12
      Sam1/3/121/5/12

       

      And I want to sum Date2 - Date1 for unique combinations. In this case, Chuck would get 2, the first line of Sam would get 2, and the next 3 lines of Sam are all identical so would count once and be 2 for a total of 6.

       

      Currently all I can get is 2+2+2+2+2=10

       

      Anybody know how to code this?