Value List Summarize

[dharkin]

Hello,

I have a field which contains a value list of check boxes with 7 skills which a user can select. I would like to know how many times certain items were selected and by gender.

Is FMP able to perform such a summary?

Thanks in advance

DH

Edited June 24, 2007 by Guest

[Vaughan]

To do this, don't use a single text field to hold the data.

Instead use a relational structure. Make each item a related record. In the master record, use a portal to display the results and allow data entry.

With each item as a separate record, generating statistics is a simple matter of making a summary report.

[Ender]

Normalizing the value list isn't necessary to get make a sub-summary report from the values.

You'd have a Sub-Summary by whatever-the-field-is part, and another Sub-Summary by Gender part. Place whatever-the-field-is and the Gender field on their corresponding part, sort the found set by whatever-the-field-is and Gender, add a Summary Count of RecordID field to whichever parts, and view the records in Preview Mode, or print to get the values to show up.

[Vaughan]

"Normalizing the value list isn't necessary to get make a sub-summary report from the values."

It is if a count of individual items is wanted.

[Ender]

Oops, you're right. I must have been thinking about something else. I gotta stop eating those mushrooms...