Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
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
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