Using a variable to store an expression?

[richnorris]

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.

[richnorris · Accepted solution]

Of course, I just had to remove the leading = sign. I am idiot.