In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Customer filter Formula - Not equal to

CDIns
8 - Asteroid

Hello, 

 

I want to filter on records in my dataset that are greater than or less than 0. For reference, this is a double data type and my current custom formula is as follows:

 

[Field1]>0 OR [Field1]<0 

 

Is there a way to write this more efficiently? I tried [Field1]<>0 but that did not work. Would if null type of formula work? if so, what would the syntax be? For reference, I use the data cleansing tool to replace nulls with 0. 

 

Thank you, 

 

1 REPLY 1
binuacs
21 - Polaris

@CDIns  Try [Field1] != 0

image.png

Labels
Top Solution Authors