Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try using:
=Firstsortedvalue(CustomerName, -OutstandingValue)
HTH
Sushil
Try using:
=Firstsortedvalue(CustomerName, -OutstandingValue)
HTH
Sushil
Thanks Sushil