summary fields and percentages

[paelman]

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?

[Fitch]

Take a look at the GetSummary function.

[paelman]

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

[Robert Kidd]

Your calc would be something like

GetSummary ( Summ_Gender; Gender) / Summ_Gender

Have a look at the attached file.

SummaryTest.zip

[comment]

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

[paelman]

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

Paelman

[paelman]

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

[paelman]

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