CMS R14 data inconsistency

[scisk]

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]

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.