Calculate the distance between address A and Adress B

[Hussein_Osseily]

Hello Everyone, 

I have column A of type long address and a column B of type long address

i am trying to use the following expression in a virtual column of type decimal to calculate the distance between Address A and Address B: 

DISTANCE(LATLONG(LAT([A]),LONG([A])),LATLONG(LAT([B]),LONG([B])))

The expression result is always 0 

am i missing something here ?  

 LATLONG(LAT([A]),LONG([A])) alone is giving the correct Latlong numbers  for both addresses A and B 

Thanks in advance

[TedM]

---

@Hussein_Osseily wrote:

 LATLONG(LAT([A]),LONG([A])) alone is giving the correct Latlong numbers  for both addresses A and B 

---

That reads as though both addresses are being assigned the same LAT LONG so the answer would be 0.

Have you tried creating VCs that work out the LATLONG for each address and then use those columns in the above expression?

Also, LAT and LONG need to be separated with a comma - is your expression putting that in?

[Steve]

AppSheet cannot determine the latitude and longitude from an address. What you're trying to do is not possible within AppSheet itself.