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
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hello, I am using Formula tool to replace values in a range with 0.00. In case the initial value is already 0.00 result is turning out to be -1.00 instead of 0.00.
How can I fix this?
Pre:
Formula: if [Field2]<=20.00 AND [Field2]>=-20.00 THEN [Field2]=0.00 ELSE [Field2] ENDIF
Post: notice record 6 was already 0.00 and formula tool replaced it with -1.00
Attached workflow. Please help!!
Solved! Go to Solution.
Hi @SDeora your syntax of the formula should be "if [Field2]<=20.00 AND [Field2]>=-20.00 THEN 0.00 ELSE [Field2] ENDIF"
