Weighted average calculation with a sample base

[Andrey_Kovalev]

Hi everyone,

Sometimes it is necessary to calculate a weighted average, for example, the cost of a unit of goods in a warehouse, despite the fact that purchases were made at different prices. For such a scenario, I made a database consisting of two related tables. Here is the link.

https://airtable.com/shrvnJDOuHiPjErXW

Since AirTable does not show how the calculated fields are made, I present them in screenshots below

Hope this can be of any help.