Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

# Calculate different resource cost against different jobw

Solved
164 4
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

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