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 Tracy Leggett
-
Nth Largest item based on Price but need to show Item #
I need to show the ITEM.CODE that has the 2nd largest UNIT.PRICE. I have entered a summary field for the UNIT.PRICE with Nth Largest, N is 2 and it returns the UNIT.PRICE. Rather that show the price, I need it to show the ITEM.CODE. I had tried a formula of …………… if {UnitPrice} = NthLargest...- Tracy Leggett
- Thread
- Replies: 1
- Forum: Business Objects:Crystal Enterprise
