This content has been marked as final. Show 3 replies
I am trying to create a chart that shows a yearly trend and for that I am using set analysis on the year:
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!