Incorrect sum of amounts

[#1]

Good day,

Within my report I have a chart with individual amounts. BUT if I want to sum these amounts, tot total is incorrect.

For instance: I have two times the number 2.08 , but Qlikview only counts one time 2.08 instead of 2.08 + 2.08.

I have for about 900 amounts to get a sum of and I have a difference of 300.000 in the total amount because of this issue.

Is there a solution to calculate each separate number in a sum?

Hope to hear...

Regards,

KJ

[#2]

Your comment is totally correct, but if you export it to excel to check the sum, you can see that the sum in excel is 130764.15.  I would expect that that also should be 145487.28..right?

[Agis-Kalogiannis · Accepted solution]

You are right.

But when you export a list box or a table box to excel, it always exports unique values, exactly as we see them in the actual object.

Agis

[#4]

Dear Agis,

ok, i have a difference in QV and SQL of 2353,69 and I wanted to check what the difference causes.

I wanted to do that in Excel, but obviously that is not the method.

any suggestion how I can check the difference?

Regards,

KJ

[Anonymous]

To check the difference, the most common way is to narrow down by making selections in QV and the addin the appropriate conditions in SQL.  Start from the field Verplichting_CustomerID, for example.