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

Convert seconds into numeric value

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

• Re: Convert seconds into numeric value

Divide all the expression by:

(24*60*60)

• Re: Convert seconds into numeric value

Try like this

NUM(

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')

)

• Re: Convert seconds into numeric value

Hi Avinash & Mindaugas,

Unfortunately, I do not get the right answer.

Thanks,

Hasvine

• Re: Convert seconds into numeric value

Thanks Amit.

It works.

KR,

Hasvine

• Re: Convert seconds into numeric value

You need it in the NUM format or what is the output your excepting ?? could you please explain us the same with an example ? so that it will help us to understand