Skip to main content

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.

Hey @Brett_Snelgrove,

This might help: Formula for percentage increase - #4 by Alex_Wolfe

Cheers,

Neil

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:


Hey @Brett_Snelgrove,

This might help: Formula for percentage increase - #4 by Alex_Wolfe

Cheers,

Neil


Thanks for the recommendation Neil 🙂

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 Justin. That’s a three cup of tea read there. I’ll check it out.


:thumbs_up: 🍵

Reply


Terms & Conditions