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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Formatting

Status
Not open for further replies.

1chicken

Programmer
Jun 11, 2003
20
US
I want to recognize the top n people on a list based on the number of people on the list. I would like to highlight the top n in red based on a number representing n. The number is the result of a percentage based array.

Help!

Robb
 
I'm not sure what you meant by your last sentence:
"The number is the result of a percentage based array."

But, if you want those records that are at or above a certain percentile for the group of records, then the following should work. Go to format section->details->color->background color->x+2 and enter:

if {table.amount} >= PthPercentile (80,{table.amount},{table.group}) then crred else crwhite

This would highlight in red all records which exceeded the 80th percentile for the particular group of records.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top