Version 10: Changing the output of a group summary count? 1

[TheElephantMan]

Hello, all.

I have a very simple report with a group that lists employees and the technologies they are familiar with:

Fred
Java
C
Jake
SQL
Visio
Jonas
None

When I use the insert summary option to display a count of each skill, those employees with a skill listing of "None" show a count of 1. I'd like the summary field to output a 0 when the contents of the skill field are "None":

Fred
Java
C
Count: 2
Jake
SQL
Visio
Count: 2
Jonas
None
Count: 0

I've created a custom formula count field, but it either displays a zero or a count of all the skills in the database, not just for each employee:

Fred
Java
C
Count: 82
Jake
SQL
Visio
Count: 82
Jonas
None
Count: 0

A little push in the right direction would be greatly appreciated.

Thanks in advance,
TEM

 

[pbateman]

There is probably a better way, but I'd create a formula like:

if {fieldname} <> 'None' then
1
else
0;

And create a sum on that.