Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Column Styling Rules Invalid Operator Error

mifosses
5 - Atom

I have a report table that has 10 rows of data to style. 

 

For reference, I am using the Dynamic or Unknown Fields workaround to apply column rules to multiple columns as outlined here 

 

For 3 of these, I have a Column Rule formula that styles it when the value is less than 89:

 

[Core Product] IN ("AS", "MS", "VOM") AND [_CurrentField_] < 89

 

This works as intended.

 

For the other 7, I thought I could use a similar formula but when the value is less than 80:

 

[Core Product] NOT IN ("AS", "MS", "VOM") AND [_CurrentField_] < 80

 

 

However, this results in a Parse Error: Invalid type in operator <

 

Not quite sure where this is going wrong, any help is appreciated. 

3 REPLIES 3
binuacs
21 - Polaris

@mifosses make sure the [_currentField_] are numeric 

mifosses
5 - Atom

Thanks, they are numeric. Not understanding why it would not impact the IN statement but does on the NOT ON statement

binuacs
21 - Polaris

@mifosses try the below formula, it is working for me

[Core Product]  NOT IN ("AS", "MS", "VOM") AND toNumber([_CurrentField_]) < 80
Labels
Top Solution Authors