Sum calculation mismatch

[gautik92]

I have no of products with a serial no

product serial no must be unique

but in a pivot table am getting sum(quantity) as 2 for 1 serial no

any idea to solve this issue

[senpradip007]

Can you share your sample app?

[gautik92]

i cant share the app

[PradeepReddy]

can you please share the data model/sample data?

without know the details it is very difficult to guess the solution...

[tamilarasu]

Hi Gowtham,

You mentioned that Sum(Quantity) for a product as 2. I guess, the product's sold quantity is 2. Could you check the Quantity field against the product. ?

[gautik92]

first column is sum(quantity)  last column is serial no.

1 quantity should have unique serial no

issue is same serial no having 2 qty

[puttemans]

Hi Gowtham,

I'd work with a mapping in the script. In the mapping, you sum the quantities, grouped by the serial number. Then you map the sum in the table, based upon the serial number.

Regards,

johan

[jonathandienst]

Without knowing the quality of the data you are loading, what you are loading  and some idea of the load script, it is not possible to say what is causing the problem, let alone trying to suggest solutions. I suggest that you prepare a sample that demonstrates the problem - use sample data that prevents disclosure of confidential information and reduce the data to a small subset to keep the upload size reasonable.

This article may help you: Preparing examples for Upload - Reduction and Data Scrambling