Calculate the distance between address A and Adress B

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

0 2 208
2 REPLIES 2
Top Labels in this Space