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
User | Count |
---|---|
18 | |
10 | |
8 | |
6 | |
5 |