Weighted average calculation with a sample base

1188 0
Showing results for 
Search instead for 
Did you mean: 
8 - Airtable Astronomer
8 - Airtable Astronomer

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.

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


Hope this can be of any help.

0 Replies 0