summary? calculation? text field

[kipp]

I have a database with a field called "presenting problem" and a drop down list of 18 possible choices (depression, anxiety, ocd,...). I wanr to report the number of files with each choice in it. Forinstance, of 236 total records, 8 have depression, six have anxiety... Then I want to have a field that tells what percent of the total this represents. Can anyone help? Thanks.

[QuinTech]

Hi, Kipp, and welcome to FM Forums! What you are trying to do is create a subsummary report. Read up on subsummaries in your manual or online. This is a fairly straightforward application of that tool.

HTH,

Jerry

[RalphL]

Welcome to the Fourm,

I assume that each record has only one choice. Make a summry field which is the count of serial number or some field that has data in every record. Sort the database by the field "presenting problem". Make a calculated number field Percentage = GetSummary (Count, presenting problem) / GetSummary (Count, Count).

In the layout set the field to display percentage.

This will display the percentage for the Problem on each record for the problem in that record..

To make a report make a columnar layout using the fields Presenting Problem and Percentage. ( you may add others) Make this a grouped report. Sort by Presenting Problem. After the layout is done you can move Percentage to the subsummary part and delete the body.