Forum Discussion
Multiply two columns from different tables, duplicates
Hi mariusz2022 ,
I suggest you to create a calculated column in "BOM" Table.
Total Missing Qty = VAR _SUM = CALCULATE(SUM(BackOrders[Qty])) RETURN BOM[BOM_Qty] * _SUMResult is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Perfect is working, thanks.
Dear vanessafvg, there are two tables, BOM and BackOrders.
In BOM table there are BOM_Item and BOM_Qty which are needed to produce 1pc of each BOM_Main_Item. In BackOrder table are Main_Items and Qty from sales orders which are missing now on the stock. I want to check how many Qty of each BOM_Item is missing.
For example:
In BOM table is Item1, which is produced from Profile1 (1pc) + Profile2 (1pc) +EPDM (6pcs) + Str1 (1pc) + Str2 (1pc)
In table BackOrders is the same Item1 5 times with quantities 15+30+100+43+125 = 313pcs
I want to check how many BOM_Items in Qty are missing, I need to count quantity from yellow column.
In above table do you see:
Profile1 - is missing: 313 pcs
Profile2 - is missing: 313 pcs
EPDM - is missing: 1878 pcs + 924 pcs = 2802 pcs in total
Str1 - is missing: 313 pcs + 308pcs = 621 pcs in total
Str2 - is missing: 313 pcs
Profile3 - is missing: 154 pcs
Profile4 - is missing: 154 pcs
I hope this is clear now.
Thanks
Mariusz
Hi mariusz2022 ,
I suggest you to create a calculated column in "BOM" Table.
Total Missing Qty =
VAR _SUM = CALCULATE(SUM(BackOrders[Qty]))
RETURN
BOM[BOM_Qty] * _SUMResult is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Perfect is working, thanks.