# Re: Calculate different resource cost against different jobw

Solved
850 1
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

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

Thanks

Ajit

1 Solution

Accepted Solutions
18 - Pluto

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

4 Replies 4
13 - Mars

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.

18 - Pluto

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

5 - Automation Enthusiast

Thank you Mohamed. This was a simple solution.

5 - Automation Enthusiast

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