3 Replies Latest reply: Mar 13, 2012 6:58 AM by ASchempp RSS

    Issue with set analysis

      Hi all,

       

      I am trying to create a chart that shows a yearly trend and for that I am using set analysis on the year:

      sum({$<Year=>}_profit)

      / sum({$<Year=>}_assets)

       

      But I have an issue with creating the correct denominator. In business terms the correct calculation is:

      (Assets current year + Assets last year)/2

       

      For the yearly trend this means:

      2009: (assets09 + assets08)/2

      2010: (assets10 + assets09)/2

      2011: (assets11 + assets10)/2

      Any ideas, how to set up the expression, so that I can show the yearly trends for above?

       

      Thanks for your help!