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

[avinashelite · Accepted solution]

Did you tried this

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

if it still does not work then please share the sample app