Problem with in data giving wrong numbers?

[qlikuser222]

Hi All,

I have a data set where i need to perform few calculations.

Due to replicates in data set i am getting wrong numbers for calculations.

Please find attached file which has sample data and please help me to resolve the issue.

Thanks

[swuehl]

What combination of dimensions would describe the unique paid amount? ID and Num?

Then maybe try

ID	sum([Paid Amount])	=Sum(Aggr([Paid Amount], ID,Num))
	600200	300100
BBB	600200	300100

But maybe it's better to remodel your data, so that facts don't get duplicated.