I'm sure this is rock-stupid, but I can't find the correct syntax anywhere.
I have a variable, vMaxYear. My expression
=
aggr(count({<Year={"$(vMaxYear)"}>} distinct dlogin),COC_Company)
works perfectly well to give me a count of "dlogin" by Company when the year = max year.
Now, I want to find out what happened in the previous year. I have tried "$(vMaxYear)-1", "$(vMaxYear-1)", "=$(vMaxYear)-1", and other
variations on the theme. None work. I have searched through the documentation, and can't find anything on the correct syntax.
Could anyone help?
