Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SchoolSubjectStudentsGradesABCMathab0ABCMathac12ABCMathad32ABDMathae1BBEnglishuu44BBEnglishud0BBEnglishua
33
School | Subject | Students | Grades |
School | Subject | Students | Grades | Class Total | Variance |
ABC | Math | ab | 10 | 55 | 10/55 |
ABC | Math | ac | 12 | 55 | 12/55 |
ABC | Math | ad | 32 | 55 | 32/55 |
ABD | Math | ae | 1 | 55 | 1/55 |
BB | English | uu | 44 | 87 | 44/87 |
BB | English | ud | 10 | 87 | 10/87 |
BB | English | ua | 33 | 87 | 33/87 |
How can i calculate Class Total. will it be formulat or set analysis.
In case Aggr() makes you happy (which doesn't make me happy because it effects performance), you can use this
Sum(Grades)/Aggr(NODISTINCT Sum(Grades), School)
Hi Sunnny
Would the formula work the same way if aggrigation was "Count" and not "SUM"
I believe it would...
Class Total
count(TOTAL <School, Subject> Grades) ?
Variance
count (Grades)/Sum(TOTAL <School, Subject> Grades) ?
or do we have to rewrite it differently.
More like this
Class Total
Count(TOTAL <School> Grades)
Variance
Count(Grades)/Count(TOTAL <School> Grades)