Can someone help?
Here is my formula in Excel if [Volume Cases]>-.99 and <.99 then "0" else [Volume Cases] endif
Alteryx does not like it.
How do I write in Alteryx?
Thanks in Advance
if [VOLUME CASES] > -.99 and [VOLUME CASES] < .99 then 0 else [VOLUME CASES] endif
Hi @CherylH
One way of doing this.
if [Volume Cases]>-.99 or [Volume Cases] <.99then "0"else [Volume Cases]endif
Many thanks
Shanker V
IF ABS([VOLUME CASES])<.99 THEN 0 ELSE [VOLUME CASES] ENDIF
Thanks this worked beautifully! Appreciate the quick resolution.