13 Replies Latest reply: Aug 10, 2016 9:21 AM by Sunny Talwar RSS

    Sum under special conditions

    Thorben Ortmann

      Hi,

       

      I have the following problem:

       

      I have a table like this:

       

      BorrowerIDAccountIDAccountExposureLtV

      11

      110040
      12210060
      13320030
      13420020
      13540060
      1465010
      14710060

       

       

      Now I want to sum the AccountExposure of all Accounts one Borrower has under the Condition that one of the belonging LtVs is greater than 50.

      So in this case the result should be (100+200+200+400+50+100) = 1050 and not (100+400+100) 600.

       

      I hope someone can help me and I am looking forward to it.

       

      Best regards

      ThorQlik