Table with shops between 2 latitudes

[kris_vliegen]

Hi All,

I have a list with shops(Fuelstations) and the latitudes and longitudes.

I also have a list with the concurrent shops with the latitude and longitude and the last fuelprices and a Slider for the zoom (5-10-15-, ... Km).

Is it possible to create a tabel with my stations and the concurrent stations with their price in the range of the zoom?

LatitudeConcurrent between  LatitudeOwn-(zoom/222) and LatitudeOwn+(zoom/222)

LongitudeConcurrent between LongitudeOwn - (Zoom / 144) and LongitudeOwn + (Zoom / 144)

This means also that a concurrent station can be linked to more than one own station.

Is this even possible and who can help me with this.

Regards,

Kris

[chrismarlow]

Hi,

Maybe like this? I set up some variables to simplify the formula;

You can then use the {1} set to cancel the selection & Only() to test the values vs the boundaries, returning Null() if outside;

Attached the QVW but on personal edition.

Cheers,

Chris.