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.