3 Replies Latest reply: Jul 15, 2015 7:01 AM by KUMAR RISHIKESH RSS

    IF function with multiple values

    KUMAR RISHIKESH

      Hi All,

       

      Can we use the below script while loading:

      sum(if(match(A,'[00:30 hrs]','[01:00 hrs]','[01:30 hrs]') and B='Processed', 1,0) ) as C

       

      If not, please suggest an alternative.

      My requirement is to get the count of total records  in a field called C where

      A=00:30 hrs , 01:00 hrs , 01:30 hrs

      and

      B=Processed

       

      TIA

       

      Regards,

      Rishikesh