2 Replies Latest reply: Dec 6, 2017 8:47 AM by Arjan IJlenhave RSS

    End of year totals

    Arjan IJlenhave

      Hi all,

       

      I have the following source data and i want to create end of year totals. Can you help?

       

      BOOKING DATA:   

      Name insuresLoss numberDate of lossBooking nr.BookdateIncurredPaid
      A13-4-201513-4-2015625000500000
      A13-4-2015212-7-2016-1000000
      A13-4-201533-5-2017500000
      B27-7-201549-7-201511000060000
      B27-7-201558-8-2017-500000
      C312-12-2016612-12-20162500025000

       

       

      An object that i want to create:

           

      Name insuredLoss
      number
      Date of loss 31-12-201531-12-201631-12-2017
      A13-apr-15Incurred625.000525.000575.000
      Paid500.000500.000500.000
      Outstanding125.00025.00075.000
      B27-jul-15Incurred110.000110.00060.000
      Paid60.00060.00060.000
      Outstanding50.00050.0000
      C312-dec-16Incurred025.00025.000
      Paid025.00025.000
      Outstanding000

       

      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