3 Replies Latest reply on Apr 24, 2018 1:39 PM by Jim Dehner

    Help with calculating a certain %

    Anders Johnson

      Sorry for the not very descriptive title, I was wondering if anyone would like to help me out with a (to me) tricky problem.

       

      I have a dataset of students, courses they have taken and grades they have received on those courses. Grades are A to F where F is failing grade. I would like to calculate the percentage of students that have gotten a passing grade (A-E) on all of their courses. So if they have a failing grade (F) in at least one course they would not be a part of the result.

       

      I'm not sure where to start, I have been looking at using some kind of LOD-function like FIXED but I'm unsure how to construct it.

       

      A sample of the dataset is in the attached packaged workbook. Anyone that could help me out with this one?

       

      Cheers,

      Anders