Cost calculation

[Ajit_Venkatesh_]

Hi

I am trying to create an airtable with resources, rate, jobs no. quantity, amount and total.

To do this I have created a master of inventory type with rate against each item.

Eg: Small Carton $ 5, Large Carton $10 etc.

Now I want to use that data for different jobs numbers. In each job i want to track the different types of resources used, quantity used, cost of each resources and total cost of resources used for each job.

Eg: Job no. 50 -
Small Carton $5 x Quantity 2 = $ 10
Large Carton $10 x Quantity 2 = $ 20
Total Cost = $30

Eg: Job no. 51 -
Small Carton $5 x Quantity 1 = $ 5
Large Carton $10 x Quantity 2 = $ 20
Total Cost = $25

Eg: Job no. 52 -
Small Carton $5 x Quantity 0 = $ 0
Large Carton $10 x Quantity 2 = $ 20
Total Cost = $20

Could you please help.

Thanks

Ajit

[Mohamed_Swella1]

Hi @Ajit_Venkatesh_R

Welcome to Airtable Community !

To do that, you have to do a Junction/Line Items table. This table will be linked to Products and to Jobs. In this table, you will enter each line item as a separate record to input the relevant quantity.

Then. using a simple Rollup field with the expression SUM(VALUE) you can get the Total Cost.

[ScottWorld · Accepted solution]

For more information on creating a junction table, check out this article on many-to-many relationships:

support.airtable.com

Many-to-Many Relationships - Overview | Airtable Support

What sets Airtable apart from ordinary spreadsheet applications is its ability to link related concepts together. Knowing how to...

[Ajit_Venkatesh_]

Thank you Mohamed. This was a simple solution.

[Ajit_Venkatesh_]

Thank you Scott. This gave a detailed explanation of many to many relationship