[sims] Students with min of AAB in 2+ Facilitating subjects calculation

[JoeS]

Please help me stop going mad here, I keep thinking I have thought of all the combinations, then I realised I've missed one!

 

I am trying to do a calculation in a SIMS template that gives a Yes or No answer to whether a student has achieved a MINIMUM of AAB, where at least 2 of the subjects are Facilitating subjects - at A Level.

 

I need to calculate each possible combination line by line in the template. Have I missed any out?

 

Note: (FS = Facilitating subject, NFS = Non Facilitating Subjects, each preceeded by a grade A or B)

 

The Answer is YES if any of the following are true:

-------------------------------------------

A-FS >= 3

A-FS >= 2 AND A-NFS >= 1

A-FS >= 2 AND B-FS >= 1

A-FS >= 2 AND B-NFS >= 1

A-FS >= 1 AND A-NFS >= 1 AND B-FS>= 1

-------------------------------------------

Else the answer is NO.

 

Thanks!

Edited June 10, 2020 by JoeS