Quantities versus sum

[#1]

Hello;

I am working on an application where the quantities are correct, but whenever I ask the sum of these the system multiplies the quantities by 4.  No ideas where this is coming from. Do you? 
Many thanks in advance.

Kristel

[kaushalview]

Hi Kristel,

Issue:

Problem is Duplication in table.

Resolution:

1) Check in script tab 'Currency Mapping' ,You have used Inner Join between two table with joining of two fields Which is wrong If you want use two fileds for joining then create composite key Like'[From currency_FCURR] &[To-currency_TCURR] '.

2) Check in script tab 'Cons Sales Order' and 'Currency Mapping' table.In these two table which is the common fileds.

3) Check and load one table with exit script step by step.

Regards

Kaushal Mehta.

'

[#3]

Hi Kristel,

In your app is every line 4 times. So you see 1 distinct line in the tablebox, but 4 * quantity in the Chart.

Best regards

Henry

[kaushalview]

Hi Kristel,

In your application the Orderqauntity fileds value showing $ times.If you want to check then use show frequency option in list box.

Solution is mantioned above

Regards

Kauhal Mehta

[#5]

Understand your point, thanks for helping.

[#6]

Again, thanks for helping.  I know now what to look for!