+ Start a Discussion
Jennifer BJennifer B 

Custom Summary Formula

Hi there,

 

I'm trying to build a number of Custom Summary Formulas that would calculate the percentage of a summarized total to the overal total, but I'm not getting anywhere. And, unfortunately, SFDC Technical Support doesn't support Custom Summary Formulas.

 

Some examples:

 

1) I have the formula for a Win-Loss Percentage based on number (#) of Opportunities Won/ Total Opportunities Closed, but I cannot figure out this same formula based on the Value ($) of the Opportunities.

 

2) We are tracking yes/no values in one of our custom objects and I want to calculate the percentage of "Yes"/ Total Responses.

 

Does anyone have any suggestions on how to build these formulas?  Or can anyone point me in the direction of resources that are not in the SFDC Help Section (which aren't overly useful).

 

Thanks in advance!

 

Jennifer 

Best Answer chosen by Admin (Salesforce Developers) 
Jennifer BJennifer B

Yes!  That worked... my #2 example is now solved.  Thank you. 

All Answers

flewellsflewells

Hi Jennifer,

 

If I understand #2 correctly, I've run into this one myself.  We have many custom picklist fields with values "Yes" and "No" to track whether something has happened.  There was a valid business reason for creating it this way, but it does prevent the calculation within reports.  The problem is that picklist values are stored as text and you need a number field for Custom Summary Formulas.  The following field types are recognized as number fields:  checkbox (true = 1, false = 0), number or currency.  In my case, I'm looking to convert these yes/no picklist fields to checkbox fields to be able to do the custom summary formulas.  Salesforce has made this conversion really easy too, you simply need to map the existing picklist values to a "checked/true" or "unchecked/false" value.  I'm happy to be proven wrong, but I don't think there's a way to get the calculation you want with your field as a picklist.

 

Kristin

Jennifer BJennifer B

Thanks Kristin - that does help for #2.  I switched to a checkbox and was able to get a percentage.

 

Any idea on how to get this percentage to show on my Dashboard instead of the value?

flewellsflewells

Try setting up a Chart within your Report.  When you setup a Chart within your Report, you can pick what you want to appear on your Y-axis and X-axis.  My guess is it defaulted to the total count, rather than your %. 

 

The dashboard picks up the Chart settings, so once you save the report, refresh your Dashboard to confirm the new settings are what you expected.

Jennifer BJennifer B

Yes!  That worked... my #2 example is now solved.  Thank you. 

This was selected as the best answer
SeaTecSeaTec

How did you do your Win loss  % calculation formula?  Im trying to do something similar.

thanks