Valdrin Posted August 18, 2015 Share 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 Link to comment Share on other sites More sharing options...
comment Posted August 18, 2015 Share Posted August 18, 2015 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. Link to comment Share on other sites More sharing options...
Valdrin Posted August 21, 2015 Author Share Posted August 21, 2015 Thanks, that is a much more elegant way to get the job done. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3298 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