Sum a collection of Latitude and Longitude Values

[RobDin]

I'm building a feature in an app that overcomes the variance of GPS readings in an area around airport interference. I've put a timer on a loop using an if statement and every time the timer ends I gather the latitude and longitude into a collection. At the end of the loop I'd like to Sum and then Average the lists of Latitude and Longitude readings I'm gathering. 

I tried Average(Sum(XCoordinates.Latitude)) but it doesn't like it. Thinking the Location.Latitude call is giving me text I also tried Average(Sum(Value(XCoordinates.Latitude))) and it also doesn't like it. 

After I've got these averages I'm going to render the results to Google Maps. Any suggestions?

[mdevaney · Accepted solution]

@RobDin 

Yes, this is possible.

First, I would suggest storing the gps coordinates as numbers in your collection.  Some code like this could be placed in the OnTimerEnd property of your timer.

Collect(myCoord, {Latitude: Value(Location.Latitude), Longitude: Value(Location.Latitude)})

Then you can find the average latitude & longitude like this.

Average(myCoord, Latitude)

Average(myCoord, Longitude)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."