11 Replies Latest reply: Oct 16, 2014 11:05 AM by Shana Forrester RSS

    check to see if a value equals selected filters

      I have loaded a table into my script with the columns 'Condition' and 'Target'. How can I check to see if my 'Condition' value equals filters selected?

      For example:

      Filters are SubRegion, Quarter, and GBU. So if I have 'Brazil' selected for SubRegion, 'Q2' selected for Quarter, and 'ABS' selected for GBU, how do I match it to my Condition value that is 'BrazilQ2ABS'?

       

      I have tried the following:

      if(Condition = concat(getfieldselection(SubRegion),getfieldselection(Quarter),getfieldselection(GBU)),Target,0)

      but it doesn't appear to be matching. Help please!