Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Weighted average calculation with a sample base

1803 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrey_Kovalev
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.

https://airtable.com/shrvnJDOuHiPjErXW

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

Andrey_Kovalev_0-1671006441354.pngAndrey_Kovalev_1-1671006484370.pngAndrey_Kovalev_2-1671006511392.png

Hope this can be of any help.

0 Replies 0