Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following problem:
I have a table like this:
BorrowerID | AccountID | AccountExposure | LtV |
---|---|---|---|
11 | 1 | 100 | 40 |
12 | 2 | 100 | 60 |
13 | 3 | 200 | 30 |
13 | 4 | 200 | 20 |
13 | 5 | 400 | 60 |
14 | 6 | 50 | 10 |
14 | 7 | 100 | 60 |
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
okay, I want to sum all K2 that belong to the same ID1, if the Max of all to ID1 belonging K3 is bigger than 55.
Moreover the Date should be the 31th of Oktober 2015 and K1 should be bigger than 5.000.000.
The result for the above fourth KPI should be about 96.642.956.
Try this:
Sum({<ID1 = {"=Max(K3)>55"}, Date = {"$(=Date(MakeDate(2015, 10, 31), 'DD.MM.YYYY'))"}, K1 = {'>5000000'}>}K2)
You are the best. Thank you very much.
Now I have to workout several other conditions, but I know it is possible and hopefully I will get everything done.
Yup, keep trying and I am sure you will figure it out