- Details
-
By Jon Hanson - Category: Uncategorised
- Hits: 67
| School ID | Name | Gender | SEN | Bursary | Scholar | Year | Form | English | Maths | Further Ma |
| 241455503251 | A, Helena | F | 9 | 09Me | 16.0 | 19.0 | - | |||
| 1339209775748 | A, Aadam | M | 9 | 09Me | 14.0 | 15.0 | - | |||
| 507213422299 | A, Gabriel | M | 9 | 09Ca | 20.0 | 17.0 | - |
=IFERROR(
AVERAGE(
FILTER(NUMBERVALUE(MID(Grades[Grade],XLOOKUP(I$1,subjectOrder[Label],subjectOrder[Byte],"-",0,1),1)),(Grades[SchoolId]=$A2)*(IFERROR(MATCH(Grades[AssociatedEntityName],FILTER(remapSubjects[oldSubject],remapSubjects[newSubject]=I$1,MAKEARRAY(1,1,LAMBDA(row,col,XLOOKUP(I$1,subjectOrder[Label],subjectOrder[Find],"-",0,1)))),0),0)),"-"))*5,TEXTJOIN("",TRUE,UNIQUE(FILTER(MID(Grades[Grade],XLOOKUP(I$1,subjectOrder[Label],subjectOrder[Byte],"-",0,1),1),(Grades[SchoolId]=$A2)*(IFERROR(MATCH(Grades[AssociatedEntityName],FILTER(remapSubjects[oldSubject],remapSubjects[newSubject]=I$1,MAKEARRAY(1,1,LAMBDA(row,col,XLOOKUP(I$1,subjectOrder[Label],subjectOrder[Find],"-",0,1)))),0),0)),"-"))))