Error With Sum Function

[mnvrma]

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;

[Kushal_Chawda]

@mnvrma  what is the expression used for "Actual Weighted Score"?

[mnvrma]

@Kushal_Chawda 

I have calculated  "Actual Weighted Score" :

Load
Year,
Name,
QuestionGroup,
"Sum Of Actual Score"*Weightage as "Actual Weighted Score"
Resident Calc;