Forum Discussion
Solved
Duplicate parts not adding up correctly
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.
DavidMcC , Not very clear.
If you want sum distinct
Sumx(Summarize(Table, Table[ReceiptBatchNumber], Table[Material Cost]), [Material Cost])
1 Reply
DavidMcC , Not very clear.
If you want sum distinct
Sumx(Summarize(Table, Table[ReceiptBatchNumber], Table[Material Cost]), [Material Cost])