Jump to content
Sign in to follow this  
paelman

summary fields and percentages

Recommended Posts

I'm not sure if this counts a a newbie question or not...but here goes.

I'm creating a survey that requires a pattern count and summary total of the specific answers...this I've scripted no problem. What I need is the ability to convert the summaries into percentages and display this beside the summary fields. I can create a percentage field, but it does not display the correct information if I place it in the summary part of my layout.

example...9 boys and 5 girls take the survey...

I pattern count for each result (patterncount gender,"boys") and the summary counts the number of boys and the number of girls(total of patterncount "boys"). I need to convert these totals into percentages (based on a total number of surveys completed) and display this information next to the summary counts of each result.

Suggestions?

Share this post


Link to post
Share on other sites

Take a look at the GetSummary function.

Share this post


Link to post
Share on other sites

when I use the getsummary function, it only references summary fields that are in existance. It won't allow me to refer to a summary field and then re-work the number as a percentage. Do you have a specific script in mind? Thank you for your response.

Paelman

Share this post


Link to post
Share on other sites

See if this helps. This file counts records by group and subgroup, and calculates the internal percentages: of each subgroup in its group, and of each group in the total.

I don't have v.5, so you'll need to convert it.

SubgroupPercent.fp3.zip

Share this post


Link to post
Share on other sites

Thank you, I'll give this a try and let the forum know if it helped.

Paelman

Share this post


Link to post
Share on other sites

Thank you, I'll give the zipfile atry and let the forum know. Thanks everyone for your help, it's been a looooong weekend of trying different scripts, so I'm very grateful for all the assistance.

Paelman

Share this post


Link to post
Share on other sites

Thanks for the help. I'll try the file and let the forum know how it went. It's been a loooong weekend of different scripting and I really appreciate the help thats been offered.

Paelman

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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