Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Percentage of various results


mrkstpls@gmail.com
 Share

Recommended Posts

I have a record with a field which can have only one of nine possible results - 1,2,3,4,5,6,7,8,or 9

Over a given set of records I want to be able to summary what percentage of the records had a 1, had a 2, etc.

The solution I've got is pretty kludge. I created 9 calculation fields, TheNumberOneField= "if(field=1,1)" ; TheNumberTwoField= "if(field=2,1)"; and so on.

The I create 9 summary fields, etc etc.

 

There are many other fields like this in my database, but creating the summary mechanism above is too time consuming. Is there a more elegant (and time saving) way to do this?

Many thanks

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use