Solved

Writing a Crystal Reports expression to get a median of Scores average

Posted on 2008-10-21
5
782 Views
Last Modified: 2013-11-15
I have the following data in a SQL Table (attached sample excel file)

This data shows the number of surveys done on each person in that list and what their score was for each and every survey. Some have more surveys than others

I want to be able to write an expression in Crystal Reports calculation that shows the average MEDIAN (%age) of ALL the survey scores, and based off of that, which of the people in that list are the top 20%, and which are the bottom 20%.

Would this have to be done in two parts? I am a NEW Crystal user. Can you guys write the expression out for me?

Thanks.
sample-data.xls
0
Comment
Question by:super786
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 22771696
The median should simply be a simple summary of the score field.

Can a person appear in both top 20% and bottom 20%
If so simply sort the records by the score and use suppression to hide the not desired records.

Suppression formula would be

RecordNumber > 0.2 * Count({SomeField}) AND RecordNumber < 0.8 * Count({SomeField})

mlmcc
0
 
LVL 1

Author Comment

by:super786
ID: 22771731
How would I calculate the summary of the score field in crystal expression form?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22773415
The easy way is to put the score field on the report in the detail section
Right click the field
Click INSERT --> SUMMARY
Choose the summary you want

mlmcc
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Diminish Pop-up  in 3 seconds 7 68
Supress a section of a field 6 29
edit .asp files 5 48
Crystal Report - Charts 4 30
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

749 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