2 Replies Latest reply: Apr 25, 2012 2:25 PM by Celambarasan Adhimulam RSS

    Get a count of a unique entry

      I am trying to a get a unique count of wheneven the Caller=INS and Primary Call Reason= Information AND Secondary Call Reason = Scheduled Items, then return 1 otherwise zero.

       

      This is the If statement I am using:

       

      IF(((CALLER= 'INS') AND (PRIMARY_CALL_REASON= 'INFORMATION')AND (SECONDARY_CALL_REASON='SCHEDULED ITEMS'))1,0)

       

      This is not working for me for some reason.

       

      Please help!

       

      Thanks!