Invalid type in operator ==.

[DeanoNY]

Good day, 

I have searched this topic all of the fields I am using are string fields and I still get the error. Any help would be appreciated 

[Emil_Kos]

Hi,

I am not able to currently validate it myself but if you are using string fields you shouldn't write your numbers in brackets? 

[estherb47 · Accepted solution]

Hi @DeanoNY 

In the first IF clause, you're comparing PR_Units as if it were text. In the others, you're comparing it as if it were a number. You need this to be the same, and based on the type of data in PR_Units

If you wanted to create a new numeric field, then create a brand new field and give it a numeric data type.

Please let me know if that helps

Cheers!

Esther

[DeanoNY]

Thank you that was the problem Pr Units was a string and either i had to put the value in quotes or change to a double with no quotes

[DeanoNY]

thank you for the prompt response I was able to get the solution