Duplicate in Total Qty

[Anonymous]

Hello!

I hope someone can help me solve my problem...  I'm trying to get a total Qty for Consign Inv which duplicates the value.

Based on my example Material 15-10791-01, I would be expecting a total of 1350 but turned out to be 2700.  I already tried using a distinct function  on the left join  and (on the expression  too)and got the same problem.  I had this kind of problem before and I just changed the total mode to sum of rows and it worked but this one doesn't.

Pls. not sure...not sure what's  the issue is.

Tks.

[Clint_Carr]

Hi,

Does it do the same without the JOIN?  That is remove the JOIN and just query the main QVD.

It appears to be a data issue to me.

[jer_2011]

hello,

within the CM column makes double,

what you could do is to exclude the data within the expression,

example sum({< CM={'CTH'}  > } [Consign Qty])

[Anonymous]

Hi!  Clint,

If  I take out the left join ,the total qty  works fine but I need to join it from the inventory table since I want to create 2 new fields Direct Part Flag and Lean Part Flag  through Base Material, Plant and CM.  Not sure if I did the right thing but  what I'm trying to get that if   3 fields Base Part Number , Plant CM from the joined table matches with Inventory table, then it will show thse Direct Part flags or Lean part flag.

Tks.