I try to calculate the distance between two zipcodes. The workbook generates longitude and latitude when I import the data, but I can't add it in a calculated field. Can anyone explain to me why and how I can use it in a calculation field?
2 answers
Good morning @Linqing Zhou
the "generated" longs" and "lats" can not be used in calculations
you will need to load longs and lats in your data upload
sorry
If this posts assists in resolving the question, please mark it as “Best Answer” or Upvote.
Also please help use better track your reply by including a mention to the volunteer who provided the answer – mine is @[Jim Dehner]
Thank you.
Jim
