--- title: Total Closed Lost Opportunity Sum | Rollup Helper Use Case Library description: How to calculate the sum of Closed Lost Opportunities for each Account record by deploying a pre-built rollup inside of Rollup Helper. image: https://www.passagetechnology.com/hubfs/Total%20Amount%20in%20Pipeline.jpg --- [GET DEMO](https://www.passagetechnology.com/any-product-one-on-one) **+1 (224) 655-6779 [![Trusted Salesforce service partner Passage Technology](https://www.passagetechnology.com/hubfs/2021/Nav-header-logo_PT.png) ](https://www.passagetechnology.com) # Total Closed Lost Opportunity Sum [![Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.](https://www.passagetechnology.com/hubfs/2021/Essential-Salesforce-Guide_Helper-Suite.png) ](https://www.passagetechnology.com/en/essential-guide-for-salesforce-admins-developers) ## Problem: How do you calculate the sum of Closed Lost Opportunities for each Account record? ## Solution: Deploy Rollup Helper's pre-built rollup "Total Closed Lost Opportunity Sum."  Quickly deploy one of Rollup Helper's pre-built rollups named, "Total Closed Lost Opportunity Sum." The Total Closed Lost Opportunity Sum use case calculates the sum of Closed Lost Opportunities for each Account record. This use case deploys one Rollup Helper setting and one field, "rhuc_Total_Closed_Lost_Opportunity_Sum." Once logged into your Salesforce organization click on the App Launcher or All Tabs and search for "Rollup Helper." Click on the "Deploy Pre-Built Rollups" tile and click "Deploy" next to the Total Closed Lost Opportunity Sum label: ![Browse Use Cases Tile](https://www.passagetechnology.com/hs-fs/hubfs/Browse%20Use%20Cases%20Tile.png?width=1303&name=Browse%20Use%20Cases%20Tile.png) ![Total Closed Lost Opportunity Sum](https://www.passagetechnology.com/hs-fs/hubfs/Total%20Closed%20Lost%20Opportunity%20Sum.jpg?width=1795&name=Total%20Closed%20Lost%20Opportunity%20Sum.jpg) - Click on the "Deploy Total Closed Lost Opportunity Sum Field" button ![Total Closed Lost Opportunity Sum deploy field](https://www.passagetechnology.com/hs-fs/hubfs/Total%20Closed%20Lost%20Opportunity%20Sum%20deploy%20field.jpg?width=1772&name=Total%20Closed%20Lost%20Opportunity%20Sum%20deploy%20field.jpg) - The Total Closed Lost Opportunity Sum field will be deployed. - Please Note: Field Level Security will not be automatically set when creating fields through Rollup Helper, and the field will not automatically be added to page layouts. Please ensure that the newly created field is added to all desired layouts and permission sets once the rollup creation process has concluded. - Then click on the "Deploy and Run Total Closed Lost Opportunity Sum Setting" button ![Total Closed Lost Opportunity Sum deploy setting](https://www.passagetechnology.com/hs-fs/hubfs/Total%20Closed%20Lost%20Opportunity%20Sum%20deploy%20setting.jpg?width=2313&name=Total%20Closed%20Lost%20Opportunity%20Sum%20deploy%20setting.jpg) - Finally, click on the "Start Rollup Run" button ![Total Closed Lost Opportunity Sum run rollup](https://www.passagetechnology.com/hs-fs/hubfs/Total%20Closed%20Lost%20Opportunity%20Sum%20run%20rollup.jpg?width=2312&name=Total%20Closed%20Lost%20Opportunity%20Sum%20run%20rollup.jpg) You will also be able to view and edit the deployed rollup via the All Rollups page. Sales leaders can use this information to do training on why certain deals are falling through. Tags: [Account](https://www.passagetechnology.com/rollup-helper-use-cases/topic/account), [Opportunity](https://www.passagetechnology.com/rollup-helper-use-cases/topic/opportunity), [SUM](https://www.passagetechnology.com/rollup-helper-use-cases/topic/sum), [Pre-Built rollup](https://www.passagetechnology.com/rollup-helper-use-cases/topic/pre-built-rollup) | [** Calculate Total Value in Opportunities Pipeline by Account ](https://www.passagetechnology.com/rollup-helper-use-cases/total-amount-in-pipeline) | [Rollup Helper Use Case Library](https://www.passagetechnology.com/rollup-helper-use-cases) | [ Total Closed Won Opportunity Sum ** ](https://www.passagetechnology.com/rollup-helper-use-cases/total-closed-won-opportunity-sum) | | --- | --- | --- | [ Optimize Sales Rep Reporting and Leaderboards in Salesforce ](https://www.passagetechnology.com/rollup-helper-use-cases/sales-rep-reporting) [ Rolling Up Marketing Cloud Account Engagement (Pardot) Activity ](https://www.passagetechnology.com/rollup-helper-use-cases/rolling-up-marketing-cloud-account-engagement-pardot-activity) [ Streamline Sales Pipeline ](https://www.passagetechnology.com/rollup-helper-use-cases/streamline-sales-pipeline) [ Creating Grandchild Rollups ](https://www.passagetechnology.com/rollup-helper-use-cases/creating-grandchild-rollups) [ Calculate the Number of Cases on a Salesforce Contact Record ](https://www.passagetechnology.com/rollup-helper-use-cases/number-of-cases-on-a-contact) [ Creating Account Hierarchy Rollups without Coding ](https://www.passagetechnology.com/rollup-helper-use-cases/account-hierarchy-rollup-without-code) [ Easily Create a Custom Last Activity (Task/Event) Date ](https://www.passagetechnology.com/rollup-helper-use-cases/last-activity-task-event-date) [ Roll-ups Using Formulas Rather than Static Criteria ](https://www.passagetechnology.com/rollup-helper-use-cases/roll-ups-using-formulas-rather-than-static-criteria) [ Identify The Primary Contact On An Account ](https://www.passagetechnology.com/rollup-helper-use-cases/identify-the-primary-contact-on-an-account) [ Opportunity Line Item Schedule Rollups ](https://www.passagetechnology.com/rollup-helper-use-cases/opportunity-line-item-schedule-rollups) © 2026 Passage Technology LLC All Rights Reserved. [Privacy Policy](https://www.passagetechnology.com/privacy-policy) | [Purchasing & Legal](https://www.passagetechnology.com/purchasing-and-legal) | [Terms of Service](https://www.passagetechnology.com/terms-of-service) | [App Security](https://passagetech.my.site.com/KnowledgeBase/s/article/Security-and-Privacy-Policy-1578080055496) - [** ](https://www.facebook.com/passagetech) - - [** ](https://www.linkedin.com/company/passage-technology) - [** ](https://www.youtube.com/channel/UCK2tzaCWVC7PmFCXrLirnZw) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Cady Wakitsch", "url" : "https://www.passagetechnology.com/rollup-helper-use-cases/author/cady-wakitsch" }, "dateModified" : "2026-04-22T14:50:52.057Z", "datePublished" : "2022-05-05T18:19:48.000Z", "headline" : "Total Closed Lost Opportunity Sum", "image" : [ "https://www.passagetechnology.com/hubfs/Total%20Amount%20in%20Pipeline.jpg" ], "mainEntityOfPage" : { "@id" : "https://www.passagetechnology.com/rollup-helper-use-cases/total-closed-lost-opportunity-sum", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.passagetechnology.com/hubfs/Logo%20PT_colors_wide_on-white.png" }, "name" : "Passage Technology LLC" } } ```