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,
