I'm looking to create a formula field on the Accounts Page. I'm not sure how to go about setting this up. It needs to calculate the Account's lead conversion rate for that Account, which would take in the 'Number of Leads Converted' over the 'Total Number of Leads'. Is this possible? I've never created a formula field and looking for guidance with this issue.

As always thanks for your time and advice.

  • Do you already have the two fields you mentioned (Total Number of Leads, and Number of Converted Leads) working on the account? Jan 21, 2015 at 16:47
  • Yeah that is the issue. It won't let me create a roll-up formula for those 2 fields and then create the percentage. Pretty lost at this point mate. Jan 21, 2015 at 16:58
  • I think it is possible through the trigger only
    – Eager
    Jan 23, 2015 at 10:19

1 Answer 1


As you called out in your comment, this would not be an issue if you could use the Standard Rollup Summary fields to count the total leads and converted leads. You cannot use the standard rollup summary to count leads on accounts though.

To get around this you have a few options. You could look on the app exchange for an app that does this for you. The advantage here is it doesn't require any custom coding on your part. I would recommend the Rollup Helper if you want to go this route. (I have no personal affiliation or interest in this product, just one that I have used int eh past and works well)


If you want to go the route of coding, there are a few nifty packages out there that I would look into

Anthony Victorio wrote a nice utility for creating your own rollups. Take a look here

Andy Fawcett also wrote a utility for this as well that you can find here

Once you choose any of these methods you can roll up your total leads and your converted leads. then you just need to create a formula field that divides them.

  • Thanks sfdc_ninja! I'll check out the resources you gave me. Jan 21, 2015 at 17:58
  • No worries. Glad to help Jan 21, 2015 at 17:58

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .