Total of fields in reports

[ktrasler]

Hi all

I have a report that is grouped by ethnicity and in each ethnic group is then grouped by gender.

My report currently shows the split of male/female in each ethnic group and shows a total in each group.

At the bottom of my report it gives me a grand total of all, but what I want is to be have a grand total of male/female.

Can I do this in the same report?

Cheers

Kev

 

[pbaldy]

Try this with the correct field name:

=Sum(IIf(Gender = "Male", 1, 0))

 

[ktrasler]

Hi

Thanks for the response.

That is counting all the times male or female appears in the report, it is not summing the amounts.

I think I have done it now after modifying your formula.

=Sum(IIf([Gender]="Female",[CountOfEthnicity],0))

This seems to work.

Thanks for your help on this.

Kev

 

[pbaldy]

Sorry, I thought you wanted a count of males/females. Glad you sorted it out.