Help

Subtracting in field - Record from Record

Topic Labels: Formulas
9340 25
cancel
Showing results for 
Search instead for 
Did you mean: 
Outside_Operato
5 - Automation Enthusiast
5 - Automation Enthusiast

Good Day,

Looking to subtract a running total collected daily from the previous total to give me the value used since the last entry.

Better explanation (I hope)
Jan 1 my total is: 1111
Jan 2 my total is 1112, so Jan 2 total - Jan 1 total = 1
Jan 3 my total is 1115, so Jan 3 - Jan 2 total = 3

The running total is kept in the same Column/Field and I want the next Column/Field to auto-calculate the difference from day to day.

In excel: Cell B2 I would use =A2-A1
Cell B3 would be =A3-A2
and so on and so on forever since the total never stop rising.

Clear as mud i hope. I’m likely just overthinking it, and not seeing the whole picture. Airtable is new to me, but if I can get this to work, it will be perfect for our needs.

Thanks,
Marc

25 Replies 25
Tuur
10 - Mercury
10 - Mercury

You could probably create something like that, but you’ll need two tables at least. Maybe some ‘master’ date table (one record for each day) and a table with the log records (changes + date reference).

Then you’ll be able to play with rollup, sum, lookup, grouping, etc. between both tables.

Thanks Tuur,

I have attempted what you suggested but I am still having problems. Would it be possible for you to provide a brief example that I could build from?

Thanks

Can you share a view (in a private message)?

Outside_Operato
5 - Automation Enthusiast
5 - Automation Enthusiast

Here is the link to the view:

I hope that it is self explanatory. I am simply trying to calculate the number of “Counts Per Day” by subtracting yesterday’s “Counter” value from today’s.

I really appreciate the help

You have a private message. :slightly_smiling_face:

I am looking for a solution similar to what I read in this thread. I use a scenario a lot, and a spreadsheet did the job. But I would prefer using AirTable. In a scenario records refer to each other. The first item will take 5 minutes, the next one 15 and so on. The table should accumulate the minutes in each record.
I wonder if anyone has a solution for this application. Would be awesome!
I tried building something with 2 tables but I keep ending up in circular reference errors.

Scenario

You should be able to build it with only this table and a reference to the former record.

So the second record has a field that links to the first one, the 3rd record links to the 2nd, etc.

I suppose you refer to an earlier message. There’s the message with a reference to a view, but I don’t find the database with the example. Do you have more information for me?
Thanks!

I was referring to your screenshot. Turn that into a table and add a linked field to itself. Link to the former record and you should be able to take it from there by adding a look up field to the ending time and doing calculations for example.

Does this help?