Is there an easier way to compute a completion status?

I am trying to compute the completion status for a student. It would be easy to say if a student completed a course, then the course is complete.

​

In my case I am trying to compute this:

​

IF a student has completed BOTH courses (ABC & DEF) then mark the student complete.

​

I thought a LOD fixed at the student ID like this would work:

​

{FIXED Student ID: MAX(IF [Course ID]='ABC' and [Course ID]='DEF' then [Completion Date] END)}

​

but this gives me a completion date for courses that are not complete and that's exactly what I don't want.

Thank you,

Scott

​

​