8 Replies Latest reply: Apr 13, 2018 9:56 AM by Sunny Talwar RSS

    set expression doesn't work with a filter

    Pasquale Cosimato


      I have this set expression as a measure in a table:


      =maxstring({<CampaignYear = {"$(=Max(CampaignYear)-1)"}>}ValueUnappraised)


      it works fine until I select a filter on a field called CampaignName.

      it is well related, I already use it in other sheet..

      Someone can see problem in the script?


      If I exclude the set expression all the table works fine even with filter on CampaignName..

      Some ideas?