2 Replies Latest reply: Jun 5, 2013 7:53 AM by Sunil Kenth RSS

    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