This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Sorry for confusion I got the result, I did change your formula as you mentioned in the comment in WF, from [RecordID] < [Source_RecordID] to [RecordID] != [Source_RecordID] and I got the accurate results. You saved my day...really appreciate it.
I had to add a formula tool to make an expected result field for the records that were within the acceptable threshold. Then for the records that need a different site, we have to rename the "source_site" to "Expected result". Note, the original was taking the expected result from the source_expected result when it should have been Source_site anyway. so this actually fixed 2 issues.