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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by dolsontopb
-
Quartile vs. Percentile Formula
Really appreciate your help on this. I have over 400 individual records grouped by benchmark positions to determine a target salary at the 75th percentile. I think I will footnote the variation in some form/fashion to cover any discrepancies that those who review the data may find if they rerun...- dolsontopb
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Quartile vs. Percentile Formula
Thanks so much for your response. I was delayed in getting back to this project due to budget planning etc. Back at it now. My formula appears accurate as follows: PthPercentile (75, {'ALL_DATA_'.Minimum}, {TOPBDATA_.TOPB Title}) When I take the same set of data and calculate the percentile...- dolsontopb
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Quartile vs. Percentile Formula
I used the Pth Percentile summary formula in a report. The result did not appear accurate. After some research and manual recalculation - there is a discrepancy in the Crystal calculation when I use the 75th percentile formula for my dataset. Therefore, I want to use 3rd quartile instead...- dolsontopb
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
