7 Replies Latest reply: Oct 4, 2012 9:29 PM by Janzen Jino Balasbas RSS

    Moving annual average


      I am trying to create a moving annual average chart. I am trying to use set analysis for this but it doesn't give any data. This is the syntax that I use:



      Sum({$<YearMonthNum ={">=$(=Date(addmonths(MakeDate(Mid(YearMonthNum,1,4),Mid(YearMonthNum,5,6)),-11),'YYYYMM')<=$(=Max(Date(MakeDate(Mid(YearMonthNum,1,4),Mid(YearMonthNum,5,6)),'YYYYMM'))"} >} amount)



      Many thanks in advance!