Hello community, I’m trying to average geographic coordinates.
First I split the coordinate into lat & lon fields, for example: 41.3310413 and 19.7828039
- In Google Sheets I’m using average() with correct result
- In Airtable the rollup with average() fails with NaN
Does anyone know another way of averaging coordinates?
PS: Also tried to remove the dot with SUBSTITUTE(Lat,".","",1) but am getting an error.