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
Solved! Go to Solution.
Hi @CherylH
One way of doing this.
if [Volume Cases]>-.99 or [Volume Cases] <.99
then "0"
else [Volume Cases]
endif
Many thanks
Shanker V
if [VOLUME CASES] > -.99 and [VOLUME CASES] < .99 then 0 else [VOLUME CASES] endif
IF ABS([VOLUME CASES])<.99 THEN 0 ELSE [VOLUME CASES] ENDIF
Thanks this worked beautifully! Appreciate the quick resolution.