YTD View

[#1]

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])

Help???

[pover · Accepted solution]

I think the formula would be a little easier it is was something like below:

sum({<Month_Start={"<=$(=Max(Month_Start)) "},Year={$(=max(Year))}>} [FIELD NAME])

Karl