Help

Calculation to track % Change in a Table

Topic Labels: Formulas
1487 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Schindler
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, I’m also new to Airtable. I’m wrestling with one thing that is very easy in Excel (or Google Sheets), but I haven’t be able to find how it can be implemented in Airtable.

I’ve created a Table. I add a record ever day to track the number of occurrences such as: Visitors to an establishment.

Date Day Visits % Change
23.3. Mo 27 NA
25.3. Tu 28 = (28/27)-1 (in formula in Excel (C2/C1) - 1
26.3. We 30 = (30/28)-1 (in formula in Excel (C3/C2) - 1
27.3 Th 35 = (35/30)-1 (in formula in Excel (C4/C3) - 1

etc

Where the % Change Column (or Field in Airtable speak) is, of course, calculated by a Formula.

Screenshot 2020-03-26 at 19.14.02

How can I achieve this with Airtable?

Any help would be very much appreciated.

Peter

4 Replies 4

Hi @Peter_Schindler,

This cannot be done in Airtable as Airtable does not recognize Records in the Formula, it recognizes Fields.

Im not sure if it can be done using the Scripting Block though.

BR,
Mo

Hello Mohamed,

thanks for your reply. So, Airtable is really more RDBMS and Spreadsheet. I’ll explore Scripting Blocks.

Cheers, Peter

MikeVK
4 - Data Explorer
4 - Data Explorer

Hi @Peter_Schindler,

Here’s a possibility:

  • Add a field that links each date to the previous date
  • Add a lookup field for the previous date’s visits
  • Add a formula field: IF({Previous Visits}, ({Visits} - {Previous Visits}) / {Previous Visits}, 0)

I tried to post a screenshot, but the forum won’t let me.

– Michael

MikeVK
4 - Data Explorer
4 - Data Explorer

Hello again @Peter_Schindler,

Now that I’m no longer a brand-new user, the forum will let me post the screenshot mentioned above.
Screen Shot 2020-04-06 at 5.21.32 PM