Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Formula Tool IF Statement

Highlighted
8 - Asteroid

Hello, 

 

I have a simple if statement in a formula tool. If [Amount] != [Payment] THEN "Incorrect" ELSE "Correct" ENDIF. However, I am noticing in my data that the amount and payment are off by like one cent so it labels the amount as incorrect. How can I update the if statement to label it as correct even if it is off by one cent? Any help would be greatly appreciated. Thank you!

Highlighted
9 - Comet

Here's one approach that I think you could take. Use one formula to check for the difference between the two and then utilize that new column in the next formula to label it as correct or incorrect.

Payment and Amount Correct.png

Labels