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?