Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Weighted average calculation with a sample base

112 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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