Duplicate parts not adding up correctly

[DavidMcC]

Hi, 

I've an issue with a few parts where they are showing as a Stock Quantity of 1 but the overall cost is showing as all 3 adding up correctly.

Below is an example of which it is showing the stock level 1 but then adding all 3 correctly together to give the correct material cost of £349. 

Any Ideas why it wouldn't pull all 3 into the stocklevel batch? They are the same part & batch number.

[amitchandak · Accepted solution]

@DavidMcC , Not very clear.

If you want sum distinct

Sumx(Summarize(Table, Table[ReceiptBatchNumber], Table[Material Cost]), [Material Cost])