Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to calculate Sum of "Actual Weighted Score" according to Year, Name
But It's coming 166.75 and 91 instead of 27.25 and 15.25 .
If we Sum "Actual Weighted Score" by year, Name. It should be 7.5+1.5+8.75+9.5=27.25 and 2.75+0.45+5.75+0.28+5.5=11.
Load
Year,
Name,
Sum("Actual Weighted Score") as "Total Of Actual Weighted Score"
Resident Calc
Group By Year,Name;
@mnvrma what is the expression used for "Actual Weighted Score"?
I have calculated "Actual Weighted Score" :
Load
Year,
Name,
QuestionGroup,
"Sum Of Actual Score"*Weightage as "Actual Weighted Score"
Resident Calc;