QGIS Field Calculator Syntax Error Problem

Question

I never before worked with the field calculator and this problem is driving me nuts ...

Interpretationserror: syntax error, unexpected NAME syntax error, unexpected ')', expecting $end

My expression is: ((“crimes_2020” - ("crimes_2017_2019” / 3)) / ("crimes_2017_2019” / 3)) * 100

Also, the Ok Button always seems to be greyed out.

At least you are using some characters which look like double quotes but actually they are something else. Look at the both sides of crimes_2020 for example. — user30184, Commented Mar 5, 2021 at 17:24

Taras · Accepted Answer · 2021-03-05 20:34:47Z

4

As was pointed by @user30184, you shall use a straight double quote " instead of the one that you used “/” (opening/closing double quote).

So your expression will look like this:

(("crimes_2020" - ("crimes_2017_2019" / 3)) / ("crimes_2017_2019" / 3)) * 100

References:

edited Mar 5, 2021 at 20:34

answered Mar 5, 2021 at 17:29

Taras♦

34k4 gold badges73 silver badges148 bronze badges

1

Thanks for this detailed answer ! Have a nice day!
– bluesharxx
Commented Mar 5, 2021 at 17:40

Add a comment |

1 Answer 1