Compare 2 columns

[mastcorp]

good evening, we have some orders shown in the first screenshot that have ID, QUANTITY, BARCODE, and we have another column where it is sales that also have id, quantity, barcode, I want to create an expression that will compare the 2 columns and give me it shows their difference, i.e. if a product has not been passed in an order to show me what it is, I have found a solution where it is a list with the formula orders[barcode]-sales[bardode] and valif if orders[ID]= Sales[ID] but it is correct only for 1 order, if other orders are added it confuses and shows other products in other orders!

[Joseph_Seddik · Accepted solution]

Subtract values from a list - AppSheet Help