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 |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |