set analysis syntax error

[#1]

Can someone please tell me whats wrong with these two syntaxes

1)

sum({<Year = ">= ($(CurrrentYear) - 2)">})

sum({<Year = ">= $(CurrrentYear) - 2">})

2)

sum({<Year = " ($(CurrrentYear) - 2)">})

Shah

[Gysbert_Wassenaar]

The part on the right side of the = sign needs to be enclosed in curly braces too:

1. sum({<Year = {">= $(CurrrentYear) - 2"} >}) 

[sivarajs]

Sum({<Year = {">= $(CurrrentYear - 2)"}>})

[#4]

still not working. I have confirmed that there is data for 2013 and 2014 and variable CurrrentYear value is 2014. I am doing some mistake in the syntamx

sum({<Year = {">= $(CurrrentYear) - 2"} >} revenue)

Shah

[anbu1984]

Can you attach sample qvw

[rubenmarin]

Hi Syed, you can try:

sum({<Year = {">= $(=CurrrentYear-2)"}>} revenue)

Check if 'currrent' (with 3 'r') is correct.

[Gysbert_Wassenaar]

Make sure to use the exact case sensitive field names.

Check that the expression works if you hard code the year:

• sum({<Year = {">=2014"} >} revenue)