29
Hi, im working in a project where i need to get location and latitudes, im trying to patch my locations using location:Substitute(Location.Latitude;”,”;”.”)
but for example when my location is 22,678282 i keep getting 22678282, im using the exact same function with Longitude and its working correctly, i also tried to invert columns and the error still happens where Latitude is writed, my database is located in Excel Online and connected via One Drive For Business
if its useful for someone i solved it using:
Text(Location.Latitude, "0.000000") instead of Substitute function, i really don't know why Longitude is working and Latitude don't but i fixed it this way.
I also tried extracting the location from "Geolocalización" column using:
Left(DataCardValue18.Text;(Find(" ";DataCardValue18.Text)) - 1)
But the latitude is still patching without the ".", so probably the issue is with Excel format, i also tried patching longitude on the "Latitud" column and it is patching correctly with the "." so the issue its a combination of format and latitude
Sure, here´s my code:
The problem is with the column "Latitud", Longitud is working good, and also Geolocalización is giving the number correctly:
Please post both numbers so that we can validate your formatting on both, so hopefully we can find out why.
Also if you can post it in the </> code snipped just to make sure pls
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
