Custom Report Help Desperately Needed

[jen1262]

While the spacing looks really odd below, this is the select statement I am getting on my test from CMS Version 9. The error is a Informix -217 and I can't seem to find the problem.......probably because I have been spoiled by the point and click of designer. This particular CMS doesn't have designer and no I can't add it ( the life expectancy of the system isn't long enough).

I am taking a report that is on a Version 11 built in Designer in another location and building it in custom.......


select sum((ACDCALLS+DA_ACDCALLS) ) ,sum((ACDTIME+DA_ACDTIME) )/sum((ACDCALLS+
DA_ACDCALLS) ) , sum((ACWTIME+DA_ACWTIM
E) )/sum((ACDCALLS+DA_ACDCALLS) ) , 100
*(sum(I_RINGTIME+I_ACDTIME+I_ACDOTHERTIM
E +I_ACDAUX_OUTTIME+I_ACDAUXINTIME+I_ACW
TIME )/sum(TI_STAFFTIME-TI_AUXTIME+I_ACD
AUX_OUTTIME+I_ACDAUXINTIME )) from hage
nt where ROW_DATE = date and ACD = 1 and
LOGID in (select value from agroups whe
re item_name = agtgrp) and STARTTIME = t
ime


In case this helps my inputs are

agtgrp for Agent Groups
date for Date
time Time point in time

The long formula is pulling agent occupancy, we run for a group of agents by interval...


Jen

 

[jfh9219]

I think you need to sum your items before using them in calculations.

When I entered

sum((ACDTIME+DA_ACDTIME) )/sum((ACDCALLS+DA_ACDCALLS))

I got an error, when I entered

(sum(ACDTIME)+sum(DA_ACDTIME))/(sum(ACDCALLS)+sum(DA_ACDCALLS))

it worked.

 

[doubledds]

It has to be in the format of (sum(ACDTIME)+sum(DA_ACDTIME)) etc and yes you will find that the field length is remarkably short!!!

smile and the whole world smiles with you... F*rt and you stand alone