Tolerance match

[aka_ash]

Hi,

I am looking to find a way to perform matching of 2 fields from different sources, i am using a joint tool to match all the other fields I require to match however i have a field where i need to apply a tolerance of +/- 1.

If there a way to perform a match of [Data 1 - Dollars] = [Data 2 - Dollars] but add a check for a tolerance of 1 (preferably using formulas)?

Below is some sample data

Data 1 - Dollars	Data 2 - Dollars	Status
1234.56	1234.56	Match
222.4442	342.23	Non-Match
222.234	223.234	Tolerance Match
222.234	222.01	Tolerance Match

Thanks in advance,

Ash

[DavidP · Accepted solution]

Hi @aka_ash 

How about an if statement like this:

IF [Data 1 - Dollars]=[Data 2 - Dollars] THEN 'Match'
ELSEIF ABS([Data 1 - Dollars]-[Data 2 - Dollars])<=1 then 'Tolerance Match'
ELSE 'Non-Match' ENDIF

[aka_ash]

That will work, thanks for the solution @DavidP 

Cheers,

Ash