Need average where value 0 is ignored 4

[jongag1]

We want to report the average call handle time for our call center. The standard average function works fine for all the values, but it also uses 0 for the average calculation.

For example:
mo 120 (seconds)
tu 145
we 160
th 116
fr 217
sa 61
su 0 (no calls received)

Crystal says (correctly) the average is 117 seconds.
I would like Crystal to ignore the 0 seconds and devide by 6 instaid of 7 and tell me the average is 136,5 seconds.

Could somebody please help me out? I probably need a formula for it, and my knowledge is not that good (yet).

Tnx in advance,
Age

 

[goranm]

Hi !

Here is one way to do it.

1.Insert a Summary that calculates the sum of your field.

2.Create a Running Total based on your field and choose
type of summary = count

3.Use a formula to evaluate it
({yourfield} <> 0

4.Create another formula where you calculate the average
(your summary-field / your Running Total-field)

I hope you understand my explanation

/Goran

 

[jongag1]

Hi,

The given solution works great, tnx Goran!
But I have different groups from which I want to calculate the average.

Tried to tell the Running total to use the group but it only can contain a field.

I have 3 groups. For example:

Helpdesk
mo 120 (seconds)
tu 145
we 160
th 116
fr 217
sa 61
su 0

Customer service
mo 100
tu 125
we 120
th 106
fr 211
sa 0
su 2

Finance
mo 110
tu 112
we 145
th 106
fr 145
sa 0
su 0

For each group I need the average and the value 0 being ignored. I hope someone can help me out.

 

[dgillz]

Reset the running total field on change of group Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[jongag1]

I love you guy's! TNX, works perfect!