Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started 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
-
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.
-
Tried this and has the following error:
Error in formula : Overflow
Line: 0, column: 0
Thanks,WA
-
Hi,
Does the formula return any valid result without for 'result.Long'?
R.
-
yes, and includes 2 decimel points
-
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.