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
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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.