5 Replies Latest reply: May 17, 2014 11:44 PM by Srikanth P RSS

    Creating a count over two fields

      Hi,

       

      I am trying to run the following as an expression on a Text Object:

       

      =count(if(status_name = 'Unassigned' or status_name = 'Unaccepted' or status_name = 'Pending' or status_name = 'On Hold'

      or status_name = 'Off Hold' and priority = 'Priority 1', priority))

       

      It should pull out 5 items, but it is pulling out 194 items instead. 

       

      What I am looking to do is get the count of all calls that are currently open on our support desk (status_name) and where the Priority also equals Priority 1.

       

      Would someone be able to help me with my coding please?

       

      Regards,

       

      Jon Ditchfield