Loading
Prepare for Email to Become the Default Login ExperienceRead More
Ongoing maintenance for Salesforce HelpRead More
Extend Salesforce with Clicks, Not Code
/ (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