Count of seperate objects

[sten28]

I'm having some trouble creating a formula that will Count something as a sub-total.

Here's the scenario:

I have a list of people; Gender is a field. I want to do a count of all people, then do a separate Count of how many Males exist and how many Females exist.

I started by trying a formula where Gender = Male; all that returned was a true/false response so trying to Count based off that formula returned a count of all persons.

I'm quite new to coding formulas in Crystal (I mostly do VB) so sorry if this is an elementary problem! Google hasn't been very helpful :\

 

[dgillz]

Write a formula:

I{Gender}="male" then 1 else 0.

Insert a simle sum on this formula. Repeat for female and you are done.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[Madawc]

You could also do it as a crosstab.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10