6 Replies Latest reply: Aug 29, 2016 8:07 AM by Hasvine Dhurmea RSS

    Convert seconds into numeric value

    Hasvine Dhurmea

      Hello All,

       

      I have a expression which returns the 119 seconds:

       

      Interval((Sum(TOTAL{<FirstAgent={'<>0'}>}conv)/Count(TOTAL{<FirstAgent={'<>0'}>}ID)/Count(DISTINCT(Date))) +(Sum(TOTAL{<FirstAgent={'<>0'}>} wrap)/Count(TOTAL{<FirstAgent={'<>0'}>}ID)/Count(DISTINCT(Date))),'ss')

       

      Now I have to convert that 119 secs into 119 as a number so that I can continue my formula.

       

      Any idea how I can do it.

       

      Thanks,

       

      Hasvine