Show Customer Name that has largest outstanding value

[Sunil_Kenth]

Hi,

In a text box, i would like to show the name of Customer that has the largest amount outstanding, a customer can have several transactions with outstanding values so i would need to sum these values and then determine who has the largest.

how can i do this?

The fields i have are CustomerName and OutstandingValue.

Thanks,

Sunil

[sushil353 · Accepted solution]

Try using:

=Firstsortedvalue(CustomerName, -OutstandingValue)

HTH

Sushil

[Sunil_Kenth]

Thanks Sushil