3 Replies Latest reply: Apr 18, 2013 8:14 AM by Kaushal Mehta RSS

    Calculating % difference between values

    James Newcombe

      Hello

       

      I know this topic has been discussed many times on this forum, but I have a slightly different question. Please see the attached QV doc and spreadsheet.

       

      I have some "triangle" data in QV. Triangle data shows the development of a figure by month for a set of origin months.

       

      So for example, it shows all claims reported in Jan-11 and shows their financial position at end Jan-11 (development month=0), end Feb-11 (development month=1), end Mar-11 (development month=2) and so on. And on the next row it shows all claims reported in Feb-11 and shows their financial position at end Feb-11 (development month=0), end Mar-11 (development month=1) and so on. Have a look at the QV doc which should hopefully clarify!

       

      I've made the triangle in QV no problem, but now I need two more triangles which show the difference between development months. The spreadsheet shows what I mean more clearly.

       

      Is it possible to create these extra difference triangles?

       

      Many thanks

      James