How to summarize the contents of a value list ?

[Inge]

Hi to all...

I have a survey DB where I ask if the people went to one restaurant or another the answer field it's linked to a value list with (yes/No) values, What I need to do is to count the number of times the people answer yes on each restaurant field. Example:

Number of records: 20

McDonalds [16] Yes [4] No

Italian food [13] Yes [7] No

I'm aware that I need to do a calculation, but I'm a newbie with FM so please be kind with me and please give me a hint to solve this little problem. Now, will the answer to the question be applied to a 3 items value list ?

Thanks for any help...

[zincb]

Instead of giving them the Yes/No, just give them a YES field. Give them a checkbox with yes -- unchecked means "no".

Then create a summary field, YES SUMMARY and make it a Count of the YES field.

Create a self-relationship based on Restaurant Name.

Then create a calculation field that gets the summary when sorted by the restaurant name = GetSummary( YES SUMMARY , RESTAURANT NAME )

Show all your records and sort on RESTAURANT NAME.

A "Self-Join::YES SUMMARY" field should show the "Yes" values you wish. Subtract from status(CurrentRecordCount) to the get "No"/no answer total.