Jump to content

Percentage Values in Found Set


This topic is 3094 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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 by comment
Link to comment
Share on other sites

This topic is 3094 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.