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?

Perhaps you could leverage the summary field type of "Fraction of Total of"

Edited September 11, 201510 yr by Kris M

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, 201510 yr by comment