Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

invalid operator==

ManuelRodrigues
8 - Asteroid

Hi 

 

I seem to be getting this error and not quite sure why it's going wrong?

 

I've tried changing formats and also changing"" to Null() with no luck?

 

ManuelRodrigues_0-1683044257826.png

 

1 REPLY 1
cjaneczko
13 - Pulsar

What is the field type of your Company Code? Just replicated the formula you have above with company code as double and it works . If the data type is String then you need to add quotes to the company codes in the formula.

 

cjaneczko_0-1683044853710.png

 

Labels