error in sintax qs

[pascos88]

Hi Guys what is wrong with this?

= MaxString({<CampaignYear_Fact = {$(CampaignYear_Fact)-1}>} ValueReviewed)

I would have the ValueReviewed value of the last year. So CampaignYear_Fact -1.

Thanks a lot

[MK_QSL]

may be try

=MaxString({<CampaignYear_Fact  = {"$(=Max(CampaignYear_Fact)-1)"}>}ValueReviewed)

[avinashelite]

$(CampaignYear_Fact)- is referring to variable or field ..if its field the your syntax is wrong

follow Manish approach

[pascos88]

it is a field... How I should write it?

[avinashelite]

Follow Manish approach that should work

=MaxString({<CampaignYear_Fact  = {"$(=Max(CampaignYear_Fact)-1)"}>}ValueReviewed)

[pascos88]

doesn't works, still in the table I got Invalid dimension. CampaignYear_Fact  is a field, and I would have info about  ValueReviewed but last years, than something like CampaignYear_Fact- 1

[avinashelite]

Your trying this in the dimension ?? try like this then

=Aggr(MaxString({<CampaignYear_Fact  = {"$(=Max(CampaignYear_Fact)-1)"}>}ValueReviewed),dimesion)

[pascos88]

unfortunately doesn't....

[chinnuchinni]

CampaignYear_Fact  is in year foamat or date_format ?

if it is in date format,use the below:

=MaxString({<CampaignYear_Fact  = {"$(=Max(Year(CampaignYear_Fact))-1)"}>}ValueReviewed)

[pascos88]

it is already in year, with this formula I get an Invalid dimension, even if the script in the table looks good. I mean onche I write the set expression, there is no error..