+ Start a Discussion
jjuezjjuez 

Help with basic % calculations

Good morning,

I have a picklist called "selection", and the values are "value1", "value2", "value3" and "value4". Users can choose one of those values inside a Case.

When I report on cases, I can create a report that groups the retrieved results by "selection", and the report will gie me the amount of times each value has been selectd, but not the percentage. How can I get that %?

The same happens with checkboxes. How do I get a percentage of cases with a checkbox selected.

And finally, with Cases "Created by": I get the amount of cases created by engineer, but not the %.

Can anyone help me out with these 3 things? I have many picklists, checkboxes, etc, and if I can get those 3 done I should be able to work out the rest myself.

Thank you very much.

Julian

BTW, I have expected calculating % to be much easier in SalesForce, kind of standard report option.