Chuck Posted September 11, 2015 Share Posted September 11, 2015 I have a text field that can be answered in one of four ways. Is there a field definition method of calculating which percentage of the found set of records have value A, which percentage have value B, etc.? So far the only methods I've thought of to do this require a script, but for something that I would anticipate is fairly common, there would seem to be a more direct method. Any suggestions? Link to comment Share on other sites More sharing options...
Kris M Posted September 11, 2015 Share Posted September 11, 2015 (edited) Perhaps you could leverage the summary field type of "Fraction of Total of" Edited September 11, 2015 by Kris M Link to comment Share on other sites More sharing options...
comment Posted September 11, 2015 Share Posted September 11, 2015 (edited) Is there a field definition method of calculating which percentage of the found set of records have value A, which percentage have value B, etc.? If you are producing a report, you can sort the found records by the field in question (let's call it Response), and use a calculation field = GetSummary ( sCount ; Response ) / sCount where sCount is a summary field, defined to count Response or any other field that cannot be empty. Perhaps you could leverage the summary field type of "Fraction of Total of" This can only be applied to numeric fields. Edited September 11, 2015 by comment Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3284 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