Avaya Support Forums

Avaya Support Forums (http://support.avaya.com/forums/index.php)
-   Contact Center Applications (http://support.avaya.com/forums/forumdisplay.php?f=3)
-   -   CMS R14 data inconsistency (http://support.avaya.com/forums/showthread.php?t=11657)

scisk 06-15-2016 11:34 PM

CMS R14 data inconsistency
 
Dear all,

I try to design a historical monthly multiagent group report. The problem i have is with below formula which should give 100 (percentage)
column 33
100*((SUM(TOTAL_ACWTIME)+SUM(TOTAL_ACDTIME)+sum(I_ RINGTIME)+sum(TI_AUXTIME)+sum(TI_AVAILTIME)+sum(TI _OTHERTIME))/sum(TI_STAFFTIME))

Above formula was build based on below:
sum(TI_STAFFTIME) = sum(I_ACDTIME + I_ACWTIME + I_DA_ACDTIME + I_DA_ACWTIME + I_RINGTIME + TI_AUXTIME + TI_AVAILTIME + TI_OTHERTIME)

I checked and there is neither I_DA_ACDTIME nor I_DA_ACWTIME reported time.

How it could be that formula from column 33 doesnt give 100 - CMS DB issue?

Thx in advance for help.

regards,
michal

shaikht 07-18-2016 02:31 AM

Hi Michal,

Will you mind sharing data for each column to see the difference. We can match it with definition to get more details on it.

I hope it helps.


All times are GMT -7. The time now is 12:38 PM.