" /> Reducing decimel points within CCPulse formula statistic - Genesys CTI User Forum

Author Topic: Reducing decimel points within CCPulse formula statistic  (Read 3262 times)

Offline PFCCWA

  • Hero Member
  • *****
  • Posts: 655
  • Karma: -7
Reducing decimel points within CCPulse formula statistic
« on: October 06, 2010, 02:25:04 PM »
Advertisement
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

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Re: Reducing decimel points within CCPulse formula statistic
« Reply #1 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.

Offline PFCCWA

  • Hero Member
  • *****
  • Posts: 655
  • Karma: -7
Re: Reducing decimel points within CCPulse formula statistic
« Reply #2 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

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Re: Reducing decimel points within CCPulse formula statistic
« Reply #3 on: October 06, 2010, 06:34:21 PM »
Hi,

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

R.

Offline PFCCWA

  • Hero Member
  • *****
  • Posts: 655
  • Karma: -7
Re: Reducing decimel points within CCPulse formula statistic
« Reply #4 on: October 06, 2010, 06:50:33 PM »
yes, and includes 2 decimel points

Offline Kevin S

  • Full Member
  • ***
  • Posts: 145
  • Karma: 4
Re: Reducing decimel points within CCPulse formula statistic
« Reply #5 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.