2 Replies Latest reply: Apr 26, 2013 10:02 AM by jagan mohan rao appala RSS

    IF with Mixmatch and And ......

    Adotey Kwame

      Hi!

       

      I dont seem to have the desired result...Help! This is what i want to do IF location is 'AC' AND 'CA' and source is 'S' then CODE

       

       

      IF(TRIM(MIXMATCH(location,'AS','CA')) AND TRIM(Source) = 'S','S') AS CODE;