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.

Calculating growth between numbers in same field

Topic Labels: Formulas
1442 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there,

So I have a Table were I am tracking Costs in one field and in another field I have Financial Years.

Financial Year
19/20
Costs
$100

Financial Year
20/21
Costs
$200

What I would like to be able to do create another field where I calculate the growth from 19/20 to 20/21:

Cost Growth
100%

I’m really not sure how to go about this. Does anyone have any suggestions?

Thanks in advance.

4 Replies 4

Comparing values between records is tricky because you’re dealing with a database, not a spreadsheet, so the records have no intrinsic relationship. This can be done with some clever setup, though, which @W_Vann_Hall outlines here:

Thanks for the recommendation Neil :slightly_smiling_face:

Thanks Justin. That’s a three cup of tea read there. I’ll check it out.

:thumbs_up: :tea: