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....