4 Replies Latest reply on Oct 5, 2017 1:13 PM by . Berrett.Rice

    Sum across unique records only - probably LOD?

    . Berrett.Rice

      I have a list of courses that repeats. I need to know how many times a student has been absent in all of their courses combined - but the courses repeat so I need to only add the absences across one instance of the courses. For example for Mary I might have two columns in the source data: Course | Absences - and they might read:

       

      Math | 1

      Reading | 2

      Science | 0

      PE | 1

      PE | 1

      Reading | 2

      Science | 0

      Math | 1

      PE | 1

      Reading | 2

       

      I would want a Sum of 1 + 2 + 0 + 1 = 4 because I'm only adding one instance of each class name, ignoring the repeated records. I am not very familiar with LODs (I have a scheduled in Vegas next week) and I wonder if that's the way to do this. Or maybe there's an easier way?