Skip to main content
I would like to show my total device support cases and then a breakdown of totals of each device with %'s. How can I do this in a report? What would the formula field need to loo like?

 

i.e

 

100 total device cases

 

30 Device A = 30%

 

29 Device B  = 29%

 

15 Device C  = 15%

 

26 Device D  = 26%
5 件の回答
  1. 2016年12月28日 18:48
    PS.  I'm using Tom Tobin's "Power of One" technique to get the distinct number of Cases (instead of just the standard Record Count / RowCount).  The API Field Name of my Case Power of One field is Case__c 

     

    Tips & Tricks: "The Power of One" the Greatest Formula Ever Written* 

     

    https://success.salesforce.com/answers?id=9063000000048RbAAI