2 Replies Latest reply: Oct 15, 2011 2:36 AM by Danijel Puco RSS

    Year to Year Analysis

      i cannot find the formula for a year to year analysis

       

      let say the following example:

       

      YearQuarter    A/R days

      2009          44

      2010          37

      2011          42

       

      I try to use the formula  :

      =Sum({$<Year={$(=Max(Year))}>}( [A/R days])) + (Sum({$<Year={$(=Max(Year)-1)}>} [A/R days]))

       

      But then, i have the following table for the selection Q1-2011

      2010     37

      2011     42

       

      now, can you tell me which formula i need to use so that the result will be

       

      2010     ( 37/44)-1

      2011      (42/37)-1

       

      thanks in advance