Subtracting a matching value across 2 data sets

[bmalkows]

I  am newer to set analysis and have an application where I am analyzing bill of material (BOM) data sets (spreadsheet imports).

Given a matching value from one data set to another I would like to subtract values (in table form).

More specfically, if I have a matching part number ("material") in two  different BOM's I would like to subtract their unit costs to see if the price is the same, and/ or there are more parts in another BOM.

My BOM's are organized in 7 digit numbers: 2 BOM's 3762416 and 3762408

Here is my set of materials for 3762416       =[3762416.3762416.Material] 

Here is my set of materials for 3762408       =[3762408.3762408.Material]

Summing of unit costs:

Sum([3762416.3762416.EPP in USD])

Sum([3762408.3762408.EPP in USD])

Please offer any set expression that may accomplish this.

[Arthur_Fong]

Could you please attach a sample app?

It is crucial to know how the datasets are being linked or joined together.

Thanks and regards,

Arthur Fong

[bmalkows · Accepted solution]

Thank you for the prompt response - I have made some headway by modifying the load script (unlocked it) via associating all the BOMs with a key - "MatKey" and it seems to be working.  I am all set for now.