Is there a problem with nthlargest???

[klameer]

Ok this is my code in basic syntax

Dim Amt1 As Number
Dim count1 As Number
count1 = 1

Amt1 = (Nthlargest(1, {TAirTrans.FATrFare},{TAirTrans.FATrSINo}))

Do while Amt1 <> Nthlargest(count1, {TAirTrans.FATrFare},{TAirTrans.FATrSINo})
count1 = count1 + 1
Loop

formula = count1

but when I look for errors it points at the count1 in the second nthlargest and says that a number is expected here well I defined it as a number didnt I???

Halp@!

 

[Naith]

You can't substitute real numbers with variables in NthLargest - which always seemed a bit retarded to me.

Can't you achieve what you're trying to do replacing NthLargest with Maximum?

Amt1 = (Maximum({TAirTrans.FATrFare},{TAirTrans.FATrSINo}))

Naith

 

[Naith]

What is this formula supposed to do? The loop's never ever going to get started. The first occurence of Count1 equals the get out clause of the loop.

Naith

 

[klameer]

Ya, I know, I would have sorted that out after I figured out why I was getting an error in the formula editor. Little steps forward Naith. Maximum won't work because if this worked there would be other procedures stemming from the value of count1. The ultimate goal would be to gove a detailed breakup of fares in an invoice. There could be 5 possible variations.