Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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