Skip to main content

Calculating growth between numbers in same field

B

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

N
Forum|alt.badge.img+4
  • nnnnneil
  • Known Participant
  • 54 replies
  • November 29, 2019

Hey @Brett_Snelgrove,
This might help: Formula for percentage increase - #4 by Alex_Wolfe
Cheers,
Neil

B
1 person likes this
  • B
    Brett_Snelgrove
Justin_Barrett
Forum|alt.badge.img+20

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:

B
1 person likes this
  • B
    Brett_Snelgrove
B
  • Brett_Snelgrove
  • Author
  • Known Participant
  • 15 replies
  • November 29, 2019
nnnnneil wrote:

Hey @Brett_Snelgrove,
This might help: Formula for percentage increase - #4 by Alex_Wolfe
Cheers,
Neil


Thanks for the recommendation Neil :slightly_smiling_face:

B
  • Brett_Snelgrove
  • Author
  • Known Participant
  • 15 replies
  • December 2, 2019
Justin_Barrett wrote:

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: :tea:

Reply


Most helpful members this week

Terms & Conditions