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

    set expression doesn't work with a filter

    Pasquale Cosimato

      HI,

      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?