Valdrin Posted August 18, 2015 Posted August 18, 2015 (edited) Hi everyone, I have a situation where there are several fields filled out with radio buttons from a value list that contains Yes, No, and Maybe. I need to extract that data and create a report that will give the percentages of how many people selected each of those choices. I can get the job done using multiple fields (say a calc field to extract the Yes, a summery field to count them, and finally a calc field to change them into a precent of the total), but I'm hoping someone has a more elegant way to do this. Thanks! Edited August 18, 2015 by Valdrin
comment Posted August 18, 2015 Posted August 18, 2015 On 8/18/2015 at 5:19 AM, Valdrin said: there are several fields filled out with radio buttons from a value list that contains Yes, No, and Maybe. In order to summarize these choices conveniently, you should have individual records for them, not fields. Then it becomes rather simple: just sort the responses by question and by response, use a summary field to count them, and a calculation field = GetSummary ( sCount ; Response ) / GetSummary ( sCount ; QuestionID ) to calculate the percentages.
Valdrin Posted August 21, 2015 Author Posted August 21, 2015 Thanks, that is a much more elegant way to get the job done.
Recommended Posts
This topic is 3544 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