Reducing decimel points within CCPulse formula statistic

General Discussion
1

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

2

Hi WA,

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

result.Long = ccpulse.group(“1”).statistic(“Calls Answered Today”) / (ccpulse.group(“1”).statistic(“Calls Answered Today”) + ccpulse.group(“2”).statistic(“Calls Abandoned Today”)) * 100

R.

3

Tried this and has the following error:

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

Thanks,WA

1 Like
4

Hi,

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

R.

1 Like
5

yes, and includes 2 decimel points

1 Like
6

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.

1 Like