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.

Sum of a Column from one table to another

Topic Labels: Formulas
795 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey,

So I have three tables, Sales, Purchases & Inventory. I have 3 items A, B, C. In each sale, a customer can buy all three, just two or one of the items in whatever quantity they wish. On each day I make purchases of varying quantities of A, B & C. I cannot figure out how to use rollup to give me a total of purchases, sales and purchases - sales in my inventory. Images of my three tables below.

Screen Shot 2020-03-12 at 1.56.31 am
Screen Shot 2020-03-12 at 1.56.22 am
Screen Shot 2020-03-12 at 1.56.13 am

2 Replies 2

Hi @Coco_Custo,

Welcome to Airtable Community !

You cannot use Rollup in your current setup. In order to use Rollup, you need to Link a field first.

So instead of have a field for item A, Field for B, field for C, and so on, you should have 1 field that is Linked to you Inventory Table where you enter the item and the qty, then you can Rollup in Inventory.

BR,
Mo

Thank you for your response. To clarify. I would create a field called product ordered and link it to inventory. And then have another column for quantity? Would this limit my customers order to a single item? So if a customer places an order that includes A & B how could I resolve that?