Arithmetic with a variable

[#1]

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?

[CELAMBARASAN · Accepted solution]

Try this

     $(=$(vMaxYear)-1)

[#3]

Perfect. Thanks so much!