How do I summarize a formula field?

[diannelight]

I have a field with a formula that works out an average. When I try to sum the total, I get an error message 'Cannot summarize this field'.
Example:
My formula is Average Duration of calls per agent. I need to calculate the total average duration for all the agents.
Thanks.

 

[dgillz]

Please post your formula and tell me where (what section) of the report it is in. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[diannelight]

My formula reads:
if {@Total Calls (Inc. Xfers)}= 0 then 0 else ({@Total Duration (Inc. Xfers)}/{@Total Calls (Inc. Xfers)})
This is the formula that I need to summarize for each agent. I have suppressed the details section so that I get one figure for each agent. So this total is being seen in the Group Header. My sum should be seen in the Group Footer.
Total Calls (Inc. Xfers) is Sum ({%Calls (Inc. Xfers)},{%Agent Name} )
and
Total Duration (Inc. Xfers) is Sum ({%Duration (Inc. Xfers)},{%Agent Name}).

 

[dgillz]

Just get rid of the argument that give you a group sum and divide like you already have:

Sum ({%Duration (Inc. Xfers)}/Sum ({%Calls (Inc. Xfers)})

This should return your total average, rathern than the average for the group {% Agent Name} Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[dgillz]

Just get rid of the argument that give you a group sum and divide like you already have:

Sum ({%Duration (Inc. Xfers)}/Sum ({%Calls (Inc. Xfers)})

This should return your total average, rather than the average for the group {% Agent Name} Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[diannelight]

I did try that formula ... unfortunately, I am also grouping by Account Code for each Agent Group.
ie. Group by Agent Group,
then by Account Code for each Agent Group
and then each Agent with that Account Code.
So my total is for each account code within the agent group.
Confused?? me too!

 

[kenhamady]

You can do the same thing with subtotals for any group level, somthing like:

If Sum ({%Calls (Inc. Xfers)},{%Agent Name} ) = 0
then 0
else Sum ({%Duration (Inc. Xfers)} ,{%Agent Name} ) /
Sum ({%Calls (Inc. Xfers)},{%Agent Name} )
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com