Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a variable 'vSummaryTrendAnalysisPCWeek' defined as the following:
= Sum({<[Week] ={">$(=num(Week(Max([Trade Date]))-13))<=$(=num(Week(Max([Trade Date]))))"}>} [$ PC])
However, if I try and plug that variable into a chart as an expression, I just get one number returned.
If I put that line in as an expression, it works fine.
I get the impression that there's some aspect of quotes and / or $ expansion of the variable that I need to use, but I can't for the life of me work out what I'm supposed to do, anyone got any ideas? Cheers.
Of course, I just had to remove the leading = sign. I am idiot.
Of course, I just had to remove the leading = sign. I am idiot.