Totals by field values

[JSMITH242B]

Hi Group,
I can't seem to create independent totals using a field. I have a title field twhich could hold any of the following values: "Mr", "Miss","Ms" or "Mrs".

I want a total number of records where the value is "Mr" to give me the total number of Males, and another where the valuee are in "Miss","Mrs" or "Ms" to give me the number of females. No matter what I do, I do not get the expected results.

Any help is much appreciated.

TIA
Jackie

 

[synapsevampire]

You can either use 2 Running Totals or create 2 formulas to sum, in either case, this will differentiate them:

Formula version:

@male
If {table.Field} = "Mr" then
1
else
0

@Female
If {table.Field} <> &quot;Mr&quot; then
1
else
0

Place these 2 formulas in your detail section, right click them and select Insert Summary->Sum.


For Running Totals, place the following in the Evaluate Use a Formula:

#Male RT:
{table.Field} = &quot;Mr&quot;

#Female RT:
{table.Field} <> &quot;Mr&quot;

-k