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
binu_acs
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

binu_acs
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