Our client is providing shipping cost quotations with the starting and destination zip codes. I’ve imported a zip code listing containing the LAT/LONG of each zip code in the US, determined the DISTANCE() between the two zip codes and multiplied to obtain the mileage ([vir_distance]*0.621371)). The client is inquiring about the difference between the Google Map mileage calculation vs. AppSheet. Can anyone provide some background and what has been implemented to help eliminate the variance?
A million thanks!
LinkedIn
Twitter
