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=>}_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!