Less than/greater than in set analysis

[jdmarlin]

Hello

I thought this would be quite straight forward but this expression doesn't aggregate between January and the maximum MONTH of the YEAR.

Sum({$<YEAR={$(=vMaxYear)}, MONTH={"<=$(=vMaxMonth)"}>} ACTIVITY)

This expression, however, works:

Sum({$<YEAR={$(=vMaxYear)}, MONTH={"<=7"}>} ACTIVITY)

[jdmarlin · Accepted solution]

Nevermind.. adding a '#' made it work

Sum({$<YEAR={$(=vMaxYear)}, MONTH={"<=$(#=vMaxMonth)"}>} ACTIVITY)