Jump to content

How to summarize the contents of a value list ?


Inge

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

Recommended Posts

  • Newbies

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...

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.