Skip to main content

Calculation to track % Change in a Table

P

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.

How can I achieve this with Airtable?

Any help would be very much appreciated.

Peter

4 replies

M
Forum|alt.badge.img+17

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

P
  • Peter_Schindler
  • Author
  • Participating Frequently
  • 6 replies
  • March 27, 2020
Mohamed_Swella1 wrote:

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

M
  • MikeVK
  • New Participant
  • 2 replies
  • April 7, 2020

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

M
  • MikeVK
  • New Participant
  • 2 replies
  • April 7, 2020

Hello again @Peter_Schindler,

Now that I’m no longer a brand-new user, the forum will let me post the screenshot mentioned above.

Reply


Most helpful members this week

Terms & Conditions