Distance() works in test but will not reflect in app

[ZOCO_Unlimited]

Hoping someone can help me with this.  

App Formula or Initial value w/ reset on edit, all I get is 0

ROUND(DISTANCE("41.03595195706428,-107.6612834947786",[LatLong]))

 

[Suvrutt_Gurjar · Accepted solution]

Please try 

ROUND(DISTANCE(LATLONG("41.03595195706428","-107.6612834947786"),[LatLong]))

in a number type column.

[ZOCO_Unlimited]

Thank you so much! This did work (quotes removed from coordinates). Is there a reason that you know of why the other way didn't work?

[Suvrutt_Gurjar]

You are welcome.

My understanding is without being wrapped by LATLONG() function, the expression on save could be interpreting the value "41.03595195706428,-107.6612834947786" as a text value rather than a latlong value. However it is true that this issue is not reflecting in the test pane. 

I requested wrapping by LATLONG() to ensure that the value does get recognized as a latlong value.

Please test well on larger number of latlong values to ensure that the expression works reliably. I of course tested it on a test app before recommending and it worked for whatever handful of test cases I tested.

[ZOCO_Unlimited]

Thank you for your explanation. The test issue is what threw me too but I updated about 100 records and it is working like a charm now. Many thanks again!