Loading
Salesforce Enforces New Security Requirements in Summer 2026Read More
Extend Salesforce with Clicks, Not Code
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            / (Divide)

            You are here:

            1. Salesforce Help
            2. Docs
            3. Extend Salesforce with Clicks, Not Code

            / (Divide)

            Divides its values.

            Required Editions

            Available in:

            Use

            value1 / value2 and replace each value with merge fields, expressions, or other numeric values.

            Revenue Amount
            Revenue Amount

            AnnualRevenue/ NumberOfEmployees

            This formula calculates the revenue amount per employee using a currency field.

            IF(NumberOfOpportunities > 0, 
  NumberOfWonOpportunities / NumberOfOpportunities, null)
            % Won Opportunities Example
            % Won Opportunities Example

            WON:SUM / RowCount calculates the percent of Won opportunities using a record count representing the number of all opportunities in your report. This formula is a number data type that returns a positive or negative integer.

            % Difference between Cost and Sales Price Example
            % Difference between Cost and Sales Price Example

            (TOTAL_PRICE:SUM - QUANTITY:SUM * Product2.Cost__c:SUM) / (QUANTITY:SUM * Product2.Cost__c:SUM) calculates the average percent difference between what a product costs and its selling price on a product-by-product level. Product2.Cost__c:SUM is a custom currency field named Cost on products, which includes the cost of each product. This formula is a percent data type that returns a positive or negative integer. For best results, use this formula on a summary Opportunities with Products report that is summarized by Product Name and includes summary totals for Quantity, Total Price, and Cost.

             
            Loading
            Salesforce Help | Article