---
title: Calculate Agent Caseload Utilization % in Salesforce | Rollup Helper Use Case Library
description: With Rollup Helper, view agent case load utilization percentage, so business decisions can be made on case reassignment or additional resources needed.
image: https://www.passagetechnology.com/hubfs/Imported_Blog_Media/img-18.png
---

[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)

# Calculate Agent Caseload Utilization % in Salesforce

[![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: An easy way to view agent case load utilization % is needed so that business decisions can be made on case reassignment or additional resources needed.

![Setup > Users](https://www.passagetechnology.com/hubfs/Imported_Blog_Media/img-18.png)

## Solution: Implement a custom field on the User object to store the case load for each User.  

This should be the number of cases expected to be assigned to that user over the same time period of the rollup.  Use Rollup Helper to roll up the number of open Cases to the User and use a formula field to determine the utilization percentage.

Create 3 fields on User:

- Number:  Expected Case Load This Month
- Number:  Actual Case Load This Month
- Formula:  Percent Utilization 
    - Formula Return Type:  Percent
    - Actual_ Case_Load_This_Month__c  /  Expected_Case_Load_This_Month__c

Create a rollup with Rollup Helper calculating the number of Open Cases this month:

1. Select Destination Object:  User
2. Select Target Field:  Actual Case Load This Month
3. Select Source Field:
   
     1. Select Child Object:  Case
     2. Select Relationship Field:  Owner ID - Case.OwnerId
     3. Which field on Case?
        
            1. Deleted
            2. Select Type:  Count
4. Create New Filter:
   
     1. Step 1. Enter Filter Name
        
            1. Open This Month
            2. Limit to should be blank
     2. Step 2. Specify Sort Order (skip this step, sorting not required)
     3. Step 3. Specify Filter Criteria
        
            1. Deleted = False (default)
            2. Closed != True
            3. Created Date >= This Month
5. Save the filter.
6. Save and Run the rollup.

For further assistance with this use case, schedule a [one-on-one demo](https://www.passagetechnology.com/any-product-one-on-one).

Have any other utilization ideas this use case could be adapted for?  Please post in the comment section below.

 

Tags: [Case](https://www.passagetechnology.com/rollup-helper-use-cases/topic/case), [User](https://www.passagetechnology.com/rollup-helper-use-cases/topic/user), [Rollup Helper](https://www.passagetechnology.com/rollup-helper-use-cases/topic/rollup-helper)

| [** Last Task Completed Subject on Contact with Hyperlink ](https://www.passagetechnology.com/rollup-helper-use-cases/last-task-completed-subject-on-contact-with-hyperlink) | [Rollup Helper Use Case Library](https://www.passagetechnology.com/rollup-helper-use-cases) | [ Sales Rep Reporting Month Part 2: Sales Rep Commission ** ](https://www.passagetechnology.com/rollup-helper-use-cases/sales-rep-reporting-month-part-2-sales-rep-commission) |
| --- | --- | --- |

[ 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://x.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" : "Susan Harris",
    "url" : "https://www.passagetechnology.com/rollup-helper-use-cases/author/susan-harris"
  },
  "dateModified" : "2026-04-21T19:23:38.986Z",
  "datePublished" : "2016-11-17T23:04:42.000Z",
  "headline" : "Calculate Agent Caseload Utilization % in Salesforce",
  "image" : [ "https://www.passagetechnology.com/hubfs/Imported_Blog_Media/img-18.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://www.passagetechnology.com/rollup-helper-use-cases/calculate-agent-caseload-utilization-in-salesforce",
    "@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"
  }
}
```