4 Replies Latest reply on Dec 8, 2017 11:12 AM by Deepak Rai

    Calculating totals PRIOR to a given year

    Sean Morris

      Hi all. This one is driving me absolutely crazy.

       

      I am trying to create a worksheet that shows students' earned GPA hours and quality points PRIOR to a certain year.

       

      Let's say that year is 2016. Student 111111 would have had 3 total GPA hours and 12 quality points prior to 2016. Student 222222 would have had 10 GPA hours and 35 quality points.

       

      What calculation can I write that will sum values per ID prior to a given year?