Solved

Crystal Formula to Calculate Average Distance Travelled

Posted on 2014-03-19
4
449 Views
Last Modified: 2014-03-19
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
0
Comment
Question by:Mark01
  • 2
  • 2
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39940254
Will the duration always be in minutes?

mlmcc
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39940284
Here is a sample report that does what you want

mlmcc
sample.rpt
0
 

Author Comment

by:Mark01
ID: 39940307
I used minutes only for the sample data. If another unit is easier for you to use, that's fine.
0
 

Author Comment

by:Mark01
ID: 39940333
It looks good. Thank you, mlmcc.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal reports - finding a hidden reference 4 77
Select Cross-tab total 2 62
Grand Totals on Crystal Reports 7 43
Summarizing a percent by a grouped category 14 26
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question