3 Replies Latest reply: Jun 25, 2015 1:36 AM by Ramya Reddy RSS

    Sum if

    Hasvine Dhurmea

      Hello Guys,

       

      I am having an issue with a variable which I am creating:

       

      =Sum({<Date={'>=$(=Date(Max(Date)))<=$(=(Date(Max(Date)))'}>}if(ConvDuration>0,1,0))

       

      Actually I need to get the total call of today whereby the conversation duration exceeded 0 seconds.

       

      Thanks for your usual help.

       

      Kind Regards,

       

      Hasvine