Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Calc_New:
I want to (Sum of Flag) by (GroupQuestions) Field but
for Name:Akshay Karbhal (No of GroupQuestions coming 4 which is correct as Sum of flag is 4 by questiongroup) but for Name: Dan Ulmamei its coming 8 instead of 4.
Load
Name,
QuestionGroup,
Sum(Flag) as "No Of GroupQuestion"
resident Calc
Group By Name,QuestionGroup;
Is it possible that some of your data is getting duplicated? The only reason for seeing 8 would be if you have the each row for Dan repeating 2 times. You might be able to resolve this using Count(DISTINCT Questions) instead of Sum(Flag), but the underlying problem of duplication can still cause issues at other places.