Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum({$<YEAR=,YEAR= {$(=YEAR(TODAY())-1)},MONTH={"<=$(=NUM(Month(today()),'#'))"}>}MOVES)
close, but try this:
Sum({$<YEAR= {$(=YEAR(TODAY())-1)},MONTH={"<=$(=NUM(Month(today()),'#')"}>}MOVES)
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.
Sum({$<YEAR=,YEAR= {$(=YEAR(TODAY())-1)},MONTH={"<=$(=NUM(Month(today()),'#'))"}>}MOVES)