# formula

This topic is 5746 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

I have a database with records of clients and want to do a report calculating different fields(age,gender,custody etc)

I am a newbie and don't know where to begin to summarize these fields

Any help???

Thanks.

##### Share on other sites

Thanks,

I want to total the number of kids from each county, the gender of each kid (how many males, females) how many are in parent custody, social services custody etc

##### Share on other sites

Sounds like you want to do a Summary report.

Create a new layout by selecting New Layout/Report under Layouts in the Menu Bar. Select Columnar List/Report as your layout type, and just follow the instructions for how to divide up your summaries.

Also, you'll want to create 1 summary field to get the Count Of a field you know will never be empty (auto-enter serial #).

Try this out and see if it makes sense. Let us know if you get stuck.

##### Share on other sites

Hi as Kent stated, you need to run summary reports. Here is a mockup file that you can disect and take a look at.

Happy holidays!

reports.zip

##### Share on other sites

looks great

Thanks so much I will try both ways

##### Share on other sites

I've been trying to replicate your report

when I look at your defined fields I see "cCount" and "SJ_age" etc. cCountCounties ( SJ_county::PersonID )

What does the "cCount" mean

What does SJ_county mean

##### Share on other sites

cCountAge is the name of the calculation field which formula is: Count ( SJ_age::PersonID )

This is basically the count of all the PersonIDs based off the 'self joining' relationship that I called SJ_age. Take a look at the relationships graph.

The self joins are based off of the value of the current record and then the count function counts all records that match the value of the current match field. In other words, if the current record has the value of 5 in the age field, the self join matches all records that have the value 5 in it. Then the calcuation counts the number of records that has 5 for the age in it.

##### Share on other sites

This topic is 5746 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account