Alteryx Designer

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

Formula Tool IF Statement

8 - Asteroid



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!

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