Problem in sum the column name

[#1]

Hello Guru's

There is a column name Peices it contains how many pieces are having for a particular shipment. In the souce when I am checking the a particular invoice it contains 41 but as the same when I am checking in QV it shows 82 pieces. (Invoice-------> Shipments -------> Pieces)

I wrote a function like Sum(Pieces), Count of Pieces and I tried Distinct alos it shows the same 82 Pieces.

How it's possible in the orginal data is having only 41 but in QV it shows 82 Pieces.

Anybody has faced such problem like this ..

Regards

Joe

[sridhar240784]

Hi Joe,

Do you have only one table where you get the shipment, invoice and pieces in it or you are trying to join more than one table to get these information.

if you are more that one table joining to arrive at this info then you need to look at you joins. improper joining of tables may cause this kind of issues.

- Sridhar

[#3]

Hello Sridhar,

Thanks for your reply, as advised by you I have checked, Invoice, pieces, shipment are all in one table (Fact table).

Even I am getting a count(shipment) is also correct(41), its something strange how to handle this...

Thanks a lot

Joe

[sridhar240784]

Hi,

Not sure why this happening  and its is very hard to suggest you also without more information.

Could you please post your data model here (i.e) Table viewer image

- Sridhar

[#5]

Dear Sridhar,

Sorry for the delay, when I was trying to upload the relational diagram its shows a error of try again later.

I don't think there is a problem in the realations because I tried several invoices its perfectly as what it is.

Only problem for one invoice the piece is doubled its really peculiar to me.

I don't know how to dig and find a solution.

Regards

Joe