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.