Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help to combine this expression in a way that work. The aim is to get students with a F or '-' in Course EN but the should also have E or better in BOTH Ma and Fy.
This is what I have
Count({< PersonID = P({<Course= {'EN'}, Grade = {'F','-'} >} PersonID), Course= {'MA','FY'}, Grade = {'A','B','C','D','E'} >} Distinct PersonID
My problem is that the expression also gives me students with E or better in either of MA or FY. I only want those with E or better in both. I have tested with diffrent combinations of >*< on the Coursefield with no luck.
Try this
Count({< PersonID = P({<Course= {'EN'}, Grade = {'F','-'} >} PersonID), Course= {'MA'}, Grade = {'A','B','C','D','E'} >*< PersonID = P({<Course= {'EN'}, Grade = {'F','-'} >} PersonID), Course= {'FY'}, Grade = {'A','B','C','D','E'} >} Distinct PersonID)
Sorry, did´t work
Attach a sample data if that could be to any help.
edit, sorry. wrong file, now the right are attached