nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Percentage Change Calculation

MCouden

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?

Vind meer berichten getagd met

Accepted answers

GeoJosh

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

All comments

MCouden

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.

MCouden

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

MCouden

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

GeoJosh

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.