Set analysis for the sum of a field not affected by selector and explicit and less than selections

[matthewp]

I have an expression:

Sum({$<YEAR=,YEAR= {$(=YEAR(TODAY())-1)},MONTH={$(=NUM(Month(today()),'#'))}>}MOVES)

Which gives me the SUM of MOVES from 2018 and Month 6

What i want is the SUM of MOVES from 2018 MONTHs 1 to 6.

I tried:

Sum({$<YEAR=,YEAR= {$(=YEAR(TODAY())-1)},MONTH<={$(=NUM(Month(today()),'#'))}>}MOVES)

But it isnt returning anything

[Gysbert_Wassenaar]

close, but try this:
Sum({$<YEAR= {$(=YEAR(TODAY())-1)},MONTH={"<=$(=NUM(Month(today()),'#')"}>}MOVES)

[matthewp]

Getting an error:
) expected

[Gysbert_Wassenaar]

Cool, you have a learning opportunity here. Try to figure out what's wrong and then fix it.

Hint: it has to do with the parentheses.

[matthewp · Accepted solution]

Sum({$<YEAR=,YEAR= {$(=YEAR(TODAY())-1)},MONTH={"<=$(=NUM(Month(today()),'#'))"}>}MOVES)