Help

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

Formulae to calculate usage

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

If I have a table as follows :

                Date/Time.   Numeric value.     Gain Since Last.      Usage per day

Record 2. 10/1/2022 100 50 10
Record 1. 1/1/2022. 50

Is there any formulae that would calculate the two fields in italics please?

Thanks in advance!

2 Replies 2

It looks like the formatting for your table got messed up by the forum software, but I’m going to guess that you come from a spreadsheet background and want to calculate how a value has changed compared to the “previous” row.

Airtable formula fields do not work across rows. This is one way in which an Airtable base is very different from a spreadsheet.

You might be able to approximate what you want by using linked record fields and linking records to their previous/next records. Then you can use lookup/rollup fields to bring the previous/next value into the current record and do calculations from there. However, maintaining all the links has its own headings. There also isn’t enough data to know if it would be possible to calculate the “Usage per day”.

Thanks for the reply - that is what I thought - linked sounds like just too much overhead!