4 Replies Latest reply on Sep 6, 2012 1:05 PM by Nick Zajchowski

    Summing Duplicate Values

    Nick Zajchowski

      I have a data set that has unique identifiers for each person (df_nr). Each person has a record every time they were sent to jail (bk_nr). I developed a calculation to determine the number of days spent in jail (using dates of entry/release) for each bk_nr. The problem is that there are duplicate records for each bk_nr, so I cannot sum up total number of days in jail by df_nr, because when it sums, it includes the days in jail for the duplicated bk_nrs.

       

      I tried the ATTR function, but it only produces a correct figure for the bk_nr - it will not let me sum the jail days by df_nr.

       

      Any thoughts?