Apex Trigger Whenever Opportunity is: Inserted/Updated/Deleted/Undeleted We need to: Calculate total Amount of all Opportunities Where StageName = 'Closed Won' And update it on Account

Apex Trigger Whenever Opportunity is: Inserted/Updated/Deleted/Undeleted We need to: Calculate total Amount of all Opportunities Where StageName = ‘Closed Won’ And update it on Account

Step 1 Create Field on Account

Create Currency field:

👉 Download Free Ebook →

👉 Get Complementary →

Field Label	API Name
Total Revenue	Total_Revenue__c

Data Type → Currency

Logic (Same Clean Pattern)

Collect AccountIds
Run ONE Aggregate SOQL using SUM(Amount)
Store result in Map
Update Accounts

Step 2 Opportunity Trigger (After Update): OpportunityRevenueSumTrigger.apxt

TRIGGER OpportunityRevenueSumTrigger ON Opportunity

(after INSERT, after UPDATE, after DELETE, after undelete) {

```
 
```
```
    Set<Id> accountIds = NEW Set<Id>();
```
```
 
```
```
    // Collect AccountIds
```

    IF(TRIGGER.isInsert || TRIGGER.isUpdate || TRIGGER.isUndelete){

        FOR(Opportunity opp : TRIGGER.new){

```
            IF(opp.AccountId != NULL){
```

                accountIds.add(opp.AccountId);

```
            }
```
```
        }
```
```
    }
```
```
 
```
```
    IF(TRIGGER.isDelete){
```

        FOR(Opportunity opp : TRIGGER.old){

```
            IF(opp.AccountId != NULL){
```

                accountIds.add(opp.AccountId);

```
            }
```
```
        }
```
```
    }
```
```
 
```
```
    IF(accountIds.isEmpty()){
```
```
        RETURN;
```
```
    }
```
```
 
```
```
    // Map TO store total revenue
```

    Map<Id, Decimal> revenueMap = NEW Map<Id, Decimal>();

```
 
```
```
    // Aggregate Query USING SUM()
```
```
    List<AggregateResult> results = [
```

        SELECT AccountId, SUM(Amount) totalAmount

```
        FROM Opportunity
```
```
        WHERE AccountId IN :accountIds
```
```
        AND StageName = 'Closed Won'
```
```
        GROUP BY AccountId
```
```
    ];
```
```
 
```
```
    // Store RESULT IN map
```
```
    FOR(AggregateResult ar : results){
```
```
 
```

        Id accId = (Id) ar.get('AccountId');

        DECIMAL totalRevenue = (DECIMAL) ar.get('totalAmount');

```
 
```

        revenueMap.put(accId, totalRevenue);

```
    }
```
```
 
```

    List<Account> accountList = NEW List<Account>();

```
 
```
```
    // UPDATE Accounts
```
```
    FOR(Id accId : accountIds){
```
```
 
```
```
        Account acc = NEW Account();
```
```
        acc.Id = accId;
```
```
 
```
```
        acc.Total_Revenue__c = 
```

            revenueMap.containsKey(accId) ? revenueMap.get(accId) : 0;

```
 
```
```
        accountList.add(acc);
```
```
    }
```
```
 
```
```
    IF(!accountList.isEmpty()){
```
```
        UPDATE accountList;
```
```
    }
```
```
}
```

Why This Is Best Practice?

Only ONE SOQL
Uses SUM() Aggregate function
No SOQL inside loop
No DML inside loop
Handles Insert, Update, Delete, Undelete
Bulk Safe (200 records)
Production-ready pattern

FAQ (Frequently Asked Questions)

How do I see all opportunities in Salesforce?

In most cases, your list view defaults to Recently Viewed. To toggle to a different list view, click the down arrow next to the list view name and select All Opportunities.

What is the bulkifying trigger in Salesforce?

The benefit of bulkifying your code is that bulkified code can process large numbers of records efficiently and run within governor limits on the Salesforce Platform. These governor limits are in place to ensure that runaway code doesn't monopolize resources on the multitenant platform.

What is the opportunity amount in Salesforce?

For Opportunities with Products, the amount is the sum of the related Products. You cannot directly edit the amount unless the Opportunity has no Products. To change the amount for an Opportunity that contains Products, edit the Sales Price or Quantity of the related Products.

Vijay Kumar

Hi, This is Vijay Kumar behind the admin and founder of w3web.net. I am a senior software developer and working in MNC company from more than 8 years. I am great fan of technology, configuration, customization & development. Apart of this, I love to write about Blogging in spare time, Working on Mobile & Web application development, Salesforce lightning, Salesforce LWC and Salesforce Integration development in full time. [Read full bio] | | The Sitemap where you can find all published post on w3web.net

How do I see all opportunities in Salesforce?

What is the bulkifying trigger in Salesforce?

What is the opportunity amount in Salesforce?

Related Topics | You May Also Like

Vijay Kumar