Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

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