Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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"
