I have actual results of the calculated percentage that I wish to match to a table that three criteria, one of which is textract the closest result to the actual results
Example
Sales 47.53 Sales tax 3.27 (6.875% tax rate)
the calculated percentage (3.27/47.53) is .068799
the other criteria I wish to match is the city name, and the five digit zip code
I have a table that has three columns ZIP, CITY_NAME and TAX_RATE
I wish to provide zip, city name and the calculated percentage and find the TAX RATE that closest matches the calculated rate
Example
Sales 47.53 Sales tax 3.27 (6.875% tax rate)
the calculated percentage (3.27/47.53) is .068799
the other criteria I wish to match is the city name, and the five digit zip code
I have a table that has three columns ZIP, CITY_NAME and TAX_RATE
I wish to provide zip, city name and the calculated percentage and find the TAX RATE that closest matches the calculated rate