Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have the following source data and i want to create end of year totals. Can you help?
BOOKING DATA:
Name insures | Loss number | Date of loss | Booking nr. | Bookdate | Incurred | Paid |
A | 1 | 3-4-2015 | 1 | 3-4-2015 | 625000 | 500000 |
A | 1 | 3-4-2015 | 2 | 12-7-2016 | -100000 | 0 |
A | 1 | 3-4-2015 | 3 | 3-5-2017 | 50000 | 0 |
B | 2 | 7-7-2015 | 4 | 9-7-2015 | 110000 | 60000 |
B | 2 | 7-7-2015 | 5 | 8-8-2017 | -50000 | 0 |
C | 3 | 12-12-2016 | 6 | 12-12-2016 | 25000 | 25000 |
An object that i want to create:
Name insured | Loss number | Date of loss | 31-12-2015 | 31-12-2016 | 31-12-2017 | |
A | 1 | 3-apr-15 | Incurred | 625.000 | 525.000 | 575.000 |
Paid | 500.000 | 500.000 | 500.000 | |||
Outstanding | 125.000 | 25.000 | 75.000 | |||
B | 2 | 7-jul-15 | Incurred | 110.000 | 110.000 | 60.000 |
Paid | 60.000 | 60.000 | 60.000 | |||
Outstanding | 50.000 | 50.000 | 0 | |||
C | 3 | 12-dec-16 | Incurred | 0 | 25.000 | 25.000 |
Paid | 0 | 25.000 | 25.000 | |||
Outstanding | 0 | 0 | 0 |
In this example you see 3 years of data, but i want to show varaible 3, 4, 5, 6, .. years of booking data.
Regards,
Arjan
Hi,
so here you transformed Bookdate = 3-4-2015 to 31-12-2015 ??
Hi,
I haven't transformed bookdate. I want in the colums the end of year standings. For example: 31-12-2015 gives a total of all bookdates <= 31-12-2015.