2 Replies Latest reply on Nov 14, 2018 8:46 AM by Jim Dehner

    Find maximum value for a customer

    Jeff Stanley

      We have a table with customer names and numbers. Each customer number is unique, but each name can have multiple customer numbers. We assign each customer "name" a risk limit, or the most they can owe us at any one time. The issue arises in that while each of the customer names has a risk level applied, the individual customer numbers may or may not. In some cases they may have the same name, but each account number may be assigned a different risk limit

       

      How would I apply the highest risk level to each name? so for "apple" the risk level would be 3000 and for tomato it would be 2000.