Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: PFCCWA on October 06, 2010, 02:25:04 PM

Title: Reducing decimel points within CCPulse formula statistic
Post by: PFCCWA on October 06, 2010, 02:25:04 PM
Hello,

I believe it is possible to reduce the decimel point of a formula statistic created within ccpulse however not sure how to do this?

The calculation behind the formula is:
ccpulse.group("1").statistic("Calls Answered Today") / (ccpulse.group("1").statistic("Calls Answered Today") + ccpulse.group("2").statistic("Calls Abandoned Today")) * 100

and results is something like 94.15, whereas I need it to show 94.

I have tried the Math.Round function but whichever combination I try doesnt appear to work advising over an overflow error.

Thanks,
WA
Title: Re: Reducing decimel points within CCPulse formula statistic
Post by: René on October 06, 2010, 04:50:22 PM
Hi WA,

You can modify the formula result by using 'result.Long/Float/Duration/Text' object:

[font=courier]result.Long = ccpulse.group("1").statistic("Calls Answered Today") / (ccpulse.group("1").statistic("Calls Answered Today") + ccpulse.group("2").statistic("Calls Abandoned Today")) * 100[/font]

R.
Title: Re: Reducing decimel points within CCPulse formula statistic
Post by: PFCCWA on October 06, 2010, 05:51:56 PM
Tried this and has the following error:

Error in formula : Overflow
Line: 0, column: 0


Thanks,WA
Title: Re: Reducing decimel points within CCPulse formula statistic
Post by: René on October 06, 2010, 06:34:21 PM
Hi,

Does the formula return any valid result without for 'result.Long'?

R.
Title: Re: Reducing decimel points within CCPulse formula statistic
Post by: PFCCWA on October 06, 2010, 06:50:33 PM
yes, and includes 2 decimel points
Title: Re: Reducing decimel points within CCPulse formula statistic
Post by: Kevin S on October 15, 2010, 01:51:57 PM
Just to make sure, have you accounted for when the denominator

(ccpulse.group("1").statistic("Calls Answered Today") + ccpulse.group("2").statistic("Calls Abandoned Today"))

could equal zero (0)? Since you cannot divide by zero, that would produce an invalid result.