ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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

@CDIns  Try [Field1] != 0

image.png

Labels
Top Solution Authors