This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

Distance calculation

Posted on 08-18-2021 03:22 PM
dessie_moonsamy
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi All

I am looking for a way to calculate the distance between 2 tables and show me a dropdown list of the stores that fall within a particular radius.

I have a table of stores and I have a table of sites. Both tables have GPS coordinates. I want to be able to allocate a store to a site depending on the distance from the site. The radius is 5km

Please can you advise on the expression I should use to give me the dropdown list.

Stay Blessed
Dessie

0 2 196
Topic Labels
0 Likes
Reply
2 REPLIES 2

Posted on --/--/---- --:-- AM
Steve
Platinum 5
Platinum 5
Reply posted on --/--/---- --:-- AM
Reply

Posted on --/--/---- --:-- AM
dessie_moonsamy
Bronze 1
Bronze 1
In response to Steve
Reply posted on --/--/---- --:-- AM

Thank you Steve…will go through this documentation and give you feedback on how I go

Reply
Top Labels in this Space