Lookup Amount tolerance in Alteryx

[griseldagomes]

Hi Experts,

Need help with looking up amounts upto $1 upwards and downwards, as per data in the Bills file.

2 inputs exist - Bills & Cash Receipt

Base file is 'Bills' which needs to be looked up in the 'Cash Receipt' file based on Account and Amount.
However, there should be a tolerance of $1 upwards and downwards while looking up the 'Cash Receipt' file.

For example, if the amount in the 'Bills' file is $100.12, the lookup tolerance should be from $99.12 to $101.12
If the match is found, then comment to be updated in the output file is 'Cash Received', else it should be 'Cash Not Received'

Thank You

[binuacs · Accepted solution]

@griseldagomes one way of doing this

[griseldagomes]

thank you @binuacs