Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Nevermind.. adding a '#' made it work
Sum({$<YEAR={$(=vMaxYear)}, MONTH={"<=$(#=vMaxMonth)"}>} ACTIVITY)
Nevermind.. adding a '#' made it work
Sum({$<YEAR={$(=vMaxYear)}, MONTH={"<=$(#=vMaxMonth)"}>} ACTIVITY)