determining a percentage off the count of drop down box.

[manoftomorrow]

Hopefully this will make sense. I am two weeks into using crystal reports, so forgive the complete lack of knowledge here.

I am trying to determine the percentage of a number. The primary field being used is a drop down box where it adds the number of times a user has made a selection. For instance, the drop down has Administrator, Other, Executive Management, etc as options. The count for administrator is 152. The total for all the options selected equals 586. How do I create a formula that will give me the percentage of 152 out of 586?

Please let me know if additional info is requested. Thanks.

M.O.T.

 

[lbass]

This sounds like a parameter selection, but if so, then not all options would necessarily appear on the report. Please use actual field names as they appear in your field list, using {@yourformulaname} for formulas, {table.name} for database fields, and {?parameter} for parameter.

Please describe your group structure and explain where the numbers you cite are coming from. Is the 152 a group subtotal?

-LB