Average summary 1

[sbelt]

Hi there,

I'm trying to do an average summary on a formula field. This formula field is like this:

if {table.date} >= Date (2004,01,01) and {table.date} < Date (2004,02,01 )
then {@workdays}
else 0

The field {@workdays} shows a number of workdays. So when I preview the report I get a list which looks like this:

User1
0
13
8
0
9

The next thing I want is to do an average summary. But when I do this it also includes the 0's in the average summary.
I want 10 but I get 6 as the result.
Is it possible to make such an summary?

Thanks in advance.
Sander

btw. I'm using CR7.

 

[Katy44]

You might have to write such a summary yourself as a few formulas, eg create a formula (myCount) to write a 1 if that formula field is not zero, and zero if it is. Put this next to your workdays field and suppress it. Then create another formula to find the sum of {@workdays} / sum of mycount. I haven't tried this, so I don't know that it will work as you want, but this would be the general idea. I hope all this is possible in 7!