We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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