1 Reply Latest reply: Dec 22, 2011 1:30 PM by Karl Pover RSS

    YTD View

      Hi, all,


      I'm trying to generate a YTD view on a certain metric, but the coding that I am using isn't working for some reason. I can't spot any syntax errors...


      The code structure that I have been playing with is as follows:


      (sum({<Month_Start={">=$(=Date(addmonths(Max(Month_Start), -(Num(Month)-1)), 'MMM-YYYY' ))<=$(=Date(addmonths(Max(Month_Start),0), 'MMM-YYYY')) "}>} [FIELD NAME])