It works fine, but I need to automate the process so it doesn't need to be changed every month. I have then created, in the load script, a variable named ThisMonthEnd. I have tried showing it in a TextBox by using the =$(ThisMonthEnd) syntax, and it works fine and displays '2014-11-31'.
But - I can't it to work in an chart expression. I tried this:
I tried it, but it still doesn't work. I get the "curly line" indicating an error at the }>} characters after the '$(ThisMonthEnd)'. However, the "Edit Expression" box still says "Expression OK". It just gives me '-' in the column in the chart.
It also doesn't work. Actually, I thought <Year=,Quarter=,Month= was a way of being sure that nothing was selected in year, quarter and month. As I stated in my question, it worked fine in the original version: