2 Replies Latest reply on Mar 15, 2016 5:22 AM by Brandy Iskin

    Fixed term

    Brandy Iskin

      I want to count the number of students based on their max term to get a distinct out for each campus.

      Ex. Student 1's campus in their max term (2015) is Campus B, Student 2's campus max term (2016) is Campus A. They may have multiple campuses and I only want to count the campus in their MAX term.

      Campus  Count

      Campus A 1

      Campus B  1

      Campus C

       

      I can find the max term for each campus: Fixed (StudentID): MAX(term) but that's as far as I got.