Newbies paelman Posted May 20, 2007 Newbies Share Posted May 20, 2007 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? Link to comment Share on other sites More sharing options...
Fitch Posted May 20, 2007 Share Posted May 20, 2007 Take a look at the GetSummary function. Link to comment Share on other sites More sharing options...
Newbies paelman Posted May 21, 2007 Author Newbies Share Posted May 21, 2007 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 Link to comment Share on other sites More sharing options...
Robert Kidd Posted May 21, 2007 Share Posted May 21, 2007 Your calc would be something like GetSummary ( Summ_Gender; Gender) / Summ_Gender Have a look at the attached file. SummaryTest.zip Link to comment Share on other sites More sharing options...
comment Posted May 21, 2007 Share Posted May 21, 2007 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 Link to comment Share on other sites More sharing options...
Newbies paelman Posted May 21, 2007 Author Newbies Share Posted May 21, 2007 Thank you, I'll give this a try and let the forum know if it helped. Paelman Link to comment Share on other sites More sharing options...
Newbies paelman Posted May 21, 2007 Author Newbies Share Posted May 21, 2007 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 Link to comment Share on other sites More sharing options...
Newbies paelman Posted May 21, 2007 Author Newbies Share Posted May 21, 2007 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6183 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 accountSign in
Already have an account? Sign in here.
Sign In Now