Invalid number for coordinate on Iphone

Question

I created a survey form using Survey123.

There are coloumns to store coordinate with formulae : round(pulldata("@geopoint", ${location}, "x"),5) and round(pulldata("@geopoint", ${location}, "y"),5)

This works fine on Android but gives out error "invalid number" on Iphone. The coordinates are different very slightly (only the last digit is different, not much).

Due to this error, the survey can not be sent from Iphone. I am using Iphone 12 and 14 to test it. All the Location -> Integrated Provider setting are the same between Android and Iphones.

I am using SDE Postgresql 16, Enterprise 11.0

need advice/  help to fix this.

Thanks

Update : I get around it by changing DOT "." into COMMA "," on the Iphone. This is NOT *convenient* because I want to lock the coordinates (users don't have the authority to update these fields). I need it to work automatically on both Iphone and Android.

yockee · Answer

Finally I know the problem: its the numbering format on Iphone..

I change the Numbering format on the IPhone, from "xy,xy.xy" to "xy.xy,xy"

Now Survey123 works on both OSs

dougbrowning · Answer

Pulldata often does not like being inside a calculation.  I would simply remove the round.  No need to reduce the accuracy.  See if that works.