Percentage Change Calculation

[MichelleCouden]

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?

[GeoJosh · Accepted solution]

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]

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

[MichelleCouden]

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

[MichelleCouden]

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.