Sum function not showing correct value

[mnvrma]

I want to see Sum of Rating_Calc

Under sum of actual score , it should be sum(Rating_Calc) means 30 but its coming 20 and 2560.photo

Table:

Load
Year,
Name,
QuestionGroup,
Rating_Calc,
Sum(Rating_Calc) as "Sum Of Actual Score"
Resident Calc
Group By Year,Name,QuestionGroup,Rating_Calc;

[Kushal_Chawda]

@mnvrma  try with distinct keyword

Sum(distinct Rating_Calc) as "Sum Of Actual Score"

[mnvrma]

@Kushal_Chawda 

No it's not working , it brings same value as column Rating_Calc

[Kushal_Chawda]

@mnvrma  please share sample data with expected output

[ramchalla]

@mnvrma please try the below in the script

Calc:

LOAD
"Year",
Name,
QuestionGroup,
Ques_Calc,
Rating_Calc
FROM [lib://dvSourceDataPath/ICO_Recharges_MI/Test/Test2.xlsx]
(ooxml, embedded labels, table is Sheet1);

Left Join (Calc)

Load
Year,
Name,
QuestionGroup,
Ques_Calc,
Sum(Rating_Calc) as "Sum Of Actual Score"
Resident Calc
Group By Year,Name,QuestionGroup,Ques_Calc;

in UI, you can simply add the measure Sum(Sum of Actual Score) to the dimensions.