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.
