Crystal Formula to Calculate Average Distance Travelled

I have to write a formula to calculate the average distance that three objects travelled. Object 1 moved at 5 mph for 1 minute. Object 2 moved at 1 mph for 2 minutes. Object 3 moved at 9 mph for 3 minutes. The screen shot shows the report with the data. Mph stands for miles per hour. The report and Access database are attached.

How do I write the formula to calculate the average distance travelled by the three objects?
Report Imagesample.rpt
sample.mdb
Mark01Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Here is a sample report that does what you want

mlmcc
sample.rpt
0
 
mlmccCommented:
Will the duration always be in minutes?

mlmcc
0
 
Mark01Author Commented:
I used minutes only for the sample data. If another unit is easier for you to use, that's fine.
0
 
Mark01Author Commented:
It looks good. Thank you, mlmcc.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.