Calculated Fields

by camel

Downloads: 23,629 (9) • Reviews: 4

Version:

1.2.9.4

Updated:

Apr 11, 2011

avgspeed show incorrectly

avgspeed show incorrectly

Postby chutchings » Sat Oct 08, 2011 7:39 am

I am trying to create some calculated fields which gives me the imperial distance, speed and pace. i have a custom field called miles and use the following formula to calculate it. {Distance}/1.609 this works correctly 65km = 40 miles
Next I created a custom field called pace per mile and this seems to work correctly with the following forumula: {Avgpace}*1.609. The next one is MPH and i just cannot get this to give sensible results.

the route is 65km= 40 miles, 3hours 45 mins = 10.6 mph

I have tried the following
{AVGSpeed)/1.609 this shows 8 which is incorrect
I have just tried showing {AVGspeed} and this should show avg 17.3kmh but shows 3. So matter what calculation I use here Avg Speed is incorrect.

Any ideas
Where there is a will there is a way
chutchings
 
Posts: 55
Joined: Wed Feb 07, 2007 2:42 pm

Re: avgspeed show incorrectly

Postby camel » Sat Oct 08, 2011 12:43 pm

Could you try to show an column for average speed in sporttracks? Bacuse it may be the same value as in plugin as far I know.
camel
Donated!
Donated!
 
Posts: 363
Joined: Tue May 18, 2010 7:14 am
Location: Slovakia

Re: avgspeed show incorrectly

Postby chutchings » Mon Oct 10, 2011 2:24 am

Sorry I did not make myself clear.
Adding just the avgspeed shows an incorrect value it does not match the average speed column in the table therefore the results for any calculation using it would also be incorrect
Where there is a will there is a way
chutchings
 
Posts: 55
Joined: Wed Feb 07, 2007 2:42 pm

Re: avgspeed show incorrectly

Postby chutchings » Mon Oct 10, 2011 10:28 am

worked it out the avgspeed field is in metres/second therefore formula pool is incorrect
Where there is a will there is a way
chutchings
 
Posts: 55
Joined: Wed Feb 07, 2007 2:42 pm


Return to Calculated Fields

Who is online

Users browsing this forum: No registered users and 2 guests