2 Replies Latest reply on Nov 30, 2017 4:01 AM by sowjanya kolluru

    extract the max sum value and the relevant grades

    sowjanya kolluru

      Hi ,

       

      I want to sum the value for a customer who has got multiple products and also want to take the highest crr values for the highest sum value. I have 2 things to do here.

      1. to calculate the sum of values for all the products for a given customer which is my global sum. so from the below example, my global exposure is 339.1

       

      2. extract the CRR value for the maximum value of the exposure: so for this I need the record for the customer to be extracted is

       

      I need my data should be looking like below for each customer:

                                         CRR   CAT-A LIMIT GLOBAL CAT-A LIMIT

      Customer Name1          5.1          211.1               339.1

       

       

       

       

       

      Please advise how can I achieve this.