Subtraction of a variable

[SerSwagster]

Hi everyone. I created this variable:

last_year = year(today())-1

In the following script, I need to do a count reffered to two years ago:

count({1<[Years]={"($(last_year) - 1)"},[Team]=P([Team])>}distinct [Player])

There is a syntax mistake when calculating last year - 1. How can I fix it?

[marcus_sommer]

You could try:

let last_year = year(today())-1;

count({1<[Years]={"$=($(last_year) - 1)"},[Team]=P([Team])>}distinct [Player])

- Marcus

[SerSwagster]

Hi Marcus,

neither with {"$=($(last_year) - 1)"}, a result is given back. It's very strange, because putting a value to years value, there is a result. There is something wrong with "$" character.

[marcus_sommer · Accepted solution]

There is a typo. Change it to:

count({1<[Years]={"$(=$(last_year) - 1)"},[Team]=P([Team])>}distinct [Player])

- Marcus