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.

How to calculate difference between 2 records?

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

Hi,
I need to calculate the evolution between two records.

Row 1 = Week 1 ; 50 followers
Row 2 = Week 2 ; 75 followers
etc…

In a column: (75-50)/50= 50% (progression of follower)
How to do it in Airtable? Thanks

2 Replies 2

Hi @Michael_Leidensdorf ,

you have to change your data structure by using one field (column) for week1, week 2, and progression of followers separately. The last field with be a function that runs the calculation.

Does it work for you ?

Thanks

Airtable does not handle running totals well. If you only want the difference, you can link each record to its predecessor and calculate the difference. However, that is a lot of linked relationships to maintain. You can also use a script to calculate a running total. There is an example script in the docs.