compare the sum of two virtual columns

[auto_724]

I need to compare the sum of two virtual columns with the same parameters from two different tables.
Example of tables:
- Table with virtual column SKU. I have the sum of all products with the same SKU, e.g.:
100 products with SKU1 and 200 products with SKU2
- A table with added SKUs (purchased products). For example, I have purchased 99 products with SKU1 and 198 products with SKU2
I need to create a view in Appsheet that will compare these 2 tables and give me the result:
SKU1 = 1 item
SKU2 = 2 items

Translated with www.DeepL.com/Translator (free version)

[SkrOYC]

First, you don't need to translate anything, this is a multi-language forum.
Second, next time, use the AppSheet Q&A section to post questions.
Third, please post your schema because I don't understand the setup your have. The part of "Table with virtual column SKU. I have the sum of all products with the same SKU" really confused me

[dbaum]

---

@SkrOYC wrote:

don't use the AppSheet Q&A section to post questions

---

[SkrOYC]

😉    

.

[auto_724]

Purchased SKU is a virtual column from Table 1:

this is initial value + purchased pieces of each SKU

I would like to add new virtual column (current stock) which will deduct all correct sales from different Table 2 and show result in this column. How can I do it to make a reference between different tables and columns?