sherikream
Registered User.
- Local time
- Yesterday, 21:10
- Joined
- Mar 27, 2013
- Messages
- 14
I want to do a count of total courses a student has passed, not including a duplicated course.
Students are required to pass 5 courses. But may have taken a course more than once to earn a higher grade even if already passed. Is there any "Count" expression or another expression to count total passed course, but not include the duplicate, for each student. Preferably keep the lower grade, for GPA calculation.
Example data below:
(if I do plain >=5 count for the below data, it counts both duplicates, which I don't want)
Course1-A
Course2-C (duplicate course, although different grade)
Course2-D (duplicate course, although different grade)
Course3-B
Course4-A
Course5-C
I need it to count only the following:
Course1-A
Course2-D (duplicate course, although different grade)
Course3-B
Course4-A
Course5-C
Thank you all in advance for any assistance.
Students are required to pass 5 courses. But may have taken a course more than once to earn a higher grade even if already passed. Is there any "Count" expression or another expression to count total passed course, but not include the duplicate, for each student. Preferably keep the lower grade, for GPA calculation.
Example data below:
(if I do plain >=5 count for the below data, it counts both duplicates, which I don't want)
Course1-A
Course2-C (duplicate course, although different grade)
Course2-D (duplicate course, although different grade)
Course3-B
Course4-A
Course5-C
I need it to count only the following:
Course1-A
Course2-D (duplicate course, although different grade)
Course3-B
Course4-A
Course5-C
Thank you all in advance for any assistance.