Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula to calcuate Lower Quartile,Upper Quartile

Status
Not open for further replies.

jarthi

Programmer
Oct 25, 2000
31
US
Hi:
Does anybody know what a quartile is ?
If so can you provide a formula for calculating quartile , just like calculating averages and medians?

Thanks,
Arthi
 
Try this, using your own field instead of Sales:

if {Sales} <= PthPercentile (25, {Sales}) then &quot;1st&quot; else
if {Sales} <= PthPercentile (50, {Sales}) then &quot;2nd&quot; else
if {Sales} <= PthPercentile (75, {Sales}) then &quot;3rd&quot; else &quot;4th&quot;

This will only work in later versions of CR that have the percentile function. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Hi Ken:
Thank you very much for the formulas. I am using Crystal 8.0 and I have this function listed in the formula editor.

Thanks,
Arthi
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top