3 Replies Latest reply on Mar 27, 2013 3:18 PM by Julian Tisdale

    Conditional Filter

    Julian Tisdale

      Have a table with transaction ID's and Product ID's.  I would like to deal with the transactions that have at least one instance of Product ID "x"

       

      My attempts to create a conditional filter on the Transaction ID field by writing a logical formula that filters for Product ID "x" has been fruitless.

       

      Both ID's are strings.

       

      Example would be like ....

       

      IIF([PRODUCT_ID] = 'X', 'Target Trans','Non Targets')

       

      I've tried CASE statements etc but am missing something here....