IF statement with >= using percentage

hi,

i am new to Alteryx and trying to build a workflow that would identify a match if Column One is less than or equal to Column Two + 10%. Column 1 is amount of money a gift cost without tax/shipping and Column 2 is the amount including tax and shipping. I need to see if the two values are similar enough for me to consider them a match.

i know this is wrong but i don't know how to fix it

if [Column 1]<=[Column 2]+10% THEN "Match" ELSE "Mismatch" ENDIF

I know the Fuzzy Match Tool exists but i haven't used it yet so i wasn't sure if this could be done given that the comparison is between numbers.

Thank you!

Best Practices

Accepted answers

DataNath

Hey @dattina2287, check the data type of your [Reimbursed Amt.] field and make sure it's numeric. The invalid type in operator message is usually when you're trying to apply mathematical operators to data types that aren't numeric i.e. strings.

All comments

DataNath

Hey @dattina2287, Alteryx doesn't recognise percentages like that so you just have to add [Column 2]*0.1 to the comparison, like so:

if [Column 1]<=([Column 2]+([Column 2]*0.1)) THEN "Match" ELSE "Mismatch" ENDIF

If statement with percentage.yxmd

dattina2287

Thank you @DataNath ! i am almost there but am getting this error below. It seems to be working until i type in "Mismatch" and then formula colors turn black.

DataNath

dattina2287

oh i should have caught that one!....it worked thanks so much @DataNath !

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703