cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RobDin
Frequent Visitor

Sum a collection of Latitude and Longitude Values

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?

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Community Champion
Community Champion

@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."

View solution in original post

1 REPLY 1
mdevaney
Community Champion
Community Champion

@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."

Helpful resources

Top Solution Authors
Top Kudoed Authors
Users online (4,181)