Trying to create valid_if expression to catch...

expressions
(Karl Alexander) #1

Trying to create valid_if expression to catch users who have location services turned off. 1st attempt: =[_THIS] <> “0.000000, 0.000000”

This worked great at first but then some phones began slipping past with entries like “0.001588, 0.000002” “-0.000397, 0.000060”

Is there an expression others are using to invalidate these geolocation entries that are results of location services being turned off?

Thank you!

(Aleksi Alkio) #2

Maybe something like DISTANCE([_THIS],LATLONG(0,0))>100

(Aleksi Alkio) #3

LATLONG(0,0) is in the middle of the sea so it can’t be ever false in real life :slight_smile:

(Karl Alexander) #4

@Aleksi_Alkio makes sense, had thot of that too but no idea how to Expression it, gonna give it a try now!

(Karl Alexander) #5

Seems to work! Will keep testing but thank you very much!

(Aleksi Alkio) #6

You’re welcome