Percentage Change Calculation

666
4
Jump to solution
06-12-2020 01:12 PM
MichelleCouden
Occasional Contributor

Trying to calculate percentage change in numbers from year 2019 to 2020. The calculation in the field calculator should be 2020 - 2019 = divided by 2019. I have tried several ways but it is not showing the correct answer. Here is what I have 4244 - 6363 = -2119 / 6363 shows -.33 percent change. [Volume_2020] - [Volume_2019] / [Volume_2019] but it gives me the answer of 4243. Am I missing same quotations?

0 Kudos
1 Solution

Accepted Solutions
GeoJosh
Esri Contributor

Hi Michelle,

The first portion of the formula needs to be in parentheses like this:

([Volume_2020] - [Volume_2019]) / [Volume_2019]

Otherwise, the division will be performed before the subtraction due to order of operations. Let me know if this works!

Best,

Josh

View solution in original post

4 Replies
GeoJosh
Esri Contributor

Hi Michelle,

The first portion of the formula needs to be in parentheses like this:

([Volume_2020] - [Volume_2019]) / [Volume_2019]

Otherwise, the division will be performed before the subtraction due to order of operations. Let me know if this works!

Best,

Josh

MichelleCouden
Occasional Contributor

Thanks. I was using brackets not parentheses. I’ll try that.

MichelleCouden
Occasional Contributor

It didn’t work. It said it didn’t like the Type Mismatch.

0 Kudos
MichelleCouden
Occasional Contributor

It worked. For some reason, it was not working inside my geodatabase. So I took it out and then did the calculation. Thanks for the help.