Year Field

[Anonymous]

I'm getting current year value from the script in a variable (vCYear). When I use this variable in Set Expression it works fine but when I try to do any subtractions like:

=sum({<FYear={$(vCYear-2)}>} Sales)

it does not work.

[Clever_Anjos · Accepted solution]

=sum({<FYear={"$(=$(vCYear)-2)"}>} Sales)

[v_iyyappan]

Hi,

Try like this

=sum({<FYear={$(=vCYear)-2}>} Sales)  or =sum({<FYear={'$(=vCYear)-2'}>} Sales)

regards,

[Anonymous]

Thank you both.

Both of the expressions that you guys mentioned worked:

=sum({<FYear={"$(=$(vCYear)-2)"}>} Sales)

and

=sum({<FYear={$(=vCYear)-2}>} Sales)