nth smallest/largest formula for groups

[jrhessey]

I'm trying to figure out the nth smallest number for a report the has unit prices in it. I can't get the nth smallest to work correctly because the unit prices are duplicated for our item numbers. Is there anyway I can create a formula that does the nth smallest for groups? Thanks for any help!

 

[synapsevampire]

Try posting technical information:

Crystal version
Database/connectivity
Example data
Expected output

-k

 

[jrhessey]

Sorry about that. Someone called me and I just clicked submit.

CR 8.5 & ODBC (MAS90).

** exapmle **

Item # Unit Price
125
.25
.25
.30
.35
.40

What I want to do is create a group for the unit price, becuase nth smallest doesn't work correctly with duplicate prices. We want the second smallest and second highest. By putting them in groups it fixes the duplicate problem. The data should return .30 and .35 prices for the second highest and smallest.