Calculating week to week numeric and percentage increase

[Chitra_Ragavan]

Hello – I’m trying to automatically figure out by how much my podcast downloads are going up, week to week and then to show percentage increase from when we first started to measure numbers. Here’s what my table looks like now. What would the formula be if it’s possible to do one?

I have a basic sum total at the bottom but would like to see each week what it’s gone up by either from the previous week or from when the episode first aired and what the percentage increase is from the time we started measuring – 10/1/19 – when the total was 2885, so I don’t have to keep doing the math!

Hmm, and it says I can’t upload an image here so not sure how to show the screenshot.

I’m an AirTable newbie, so any help, welcome!

Thanks!

[Justin_Barrett]

Welcome to the community, @Chitra_Ragavan! :grinning_face_with_big_eyes: You can’t post images yet because you’re a new forum user. Once you’ve been active here a while, the system will automatically start removing certain restrictions.

To answer your question, cross-record calculations are possible in Airtable, but it’s a tricky setup because Airtable is a database and not a spreadsheet. Database records have no intrinsic knowledge of each other, so it’s not a simple matter of writing a formula that refers to another record. This post goes into great detail on how to make it work:

Multi-record calculations (c.f. 'running balance,' 'row number,' and the like) Show and tell

tl;dr version: A frequent query and/or complaint concerns users who wish to access data from a record for use in a calculation performed in a different record from the same table. Often this takes the form of a user asking ‘how to retrieve a value based on row number’; other times the user wishes to perform a calculation that assumes knowledge of the previous record — for instance, maintaining a running balance. A recently published base contains four approaches to this problem, three involving …

[Chitra_Ragavan]

Thank you. That’s helpful. I will study that example. But maybe it would be easier for me to do that type of numbers crunching on Excel.