Crystal reports formula help

[reacha]

i have a field called callid,talktime,agentid

In the report i have group by agentid and i have duplicate callid's

i need the sum(agenttalktime) for that particular agentid.

if there is duplicate callid then the agenttalktime is adding up twice depending on the duplicates

i am trying to do something like this

talktime :if callid <> next(callid) then agenttalktime

and when i am trying to use sum function on agenttalktime its not coming up .

when i try to write the formula to calculate
sum(talktime,agentid)

getting error as field cannot be summarized


Please help me out!!

 

[FireGeek21]

Do you have any groups? Where are you putting the Sum(talktime,agentid)?

I have used this type of formula before and have put it in the Report -> Selection Formula -> Group area. You would then have to group by agentid if you do this.

Hope this helps.

FireGeek
(currently using Crystal Reports XI with Lawson 8.03)

 

[reacha]

i am putting that in the group header of agentid




Thanks,
reacha

 

[FireGeek21]

Put it in the Report -> Selection Formula -> Group area. You would then have to group by agentid.

FireGeek
(currently using Crystal Reports XI with Lawson 8.03)

 

[reacha]

i had duplicate callid's so when i calculate sum(talktime) then the sum is getting added up twice

so i am trying to avoid that using the formula as

if callid <> next(callid) then talktime

then i want to use the sum function on this formula so that i can sum it up by agentid but getting error as
field cannot be summaried

i tried this Report -> Selection Formula -> Group area.

and still getting the error field cannot be summaried

 

[lbass]

Add a sort or group by CallID and then insert a running total that does a sum and evaluates on change of the callID field or group, and resets on change of the agent field. Place the running total in the group footer.

-LB

 

[reacha]

I am still getting the wrong results.

I have used callid field in the evaluate

and change of agentid group in reset

and placed that talktime in the group footer of agentid
but still getting the incorrect results

 

[lbass]

Please show some sample data, and also explain specifically how you set up the running total, and then show how it is displaying when placed in the group footer.

You aren't suppressing any records are you?

-LB