Examples of Advanced Formula Fields

Examples of Advanced Formula Fields
Sample Account Management Formulas
Sample Account Media Service Formulas
Sample Case Management Formulas
Sample Commission Calculations Formulas
Sample Contact Management Formulas
Sample Data Categorization Formulas
Using Date, Date/Time, and Time Values in Formulas
Sample Discounting Formulas
Sample Employee Services Formulas
Sample Expense Tracking Formulas
Sample Financial Calculations Formulas
Sample Image Link Formulas
Sample Integration Link Formulas
Sample Lead Management Formulas
Sample Metric Formulas
Sample Opportunity Management Formulas
Sample Pricing Formulas
Sample Scoring Calculations Formulas
Formula Operators and Functions by Context
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Sample Expense Tracking Formulas

Available in: both Salesforce Classic and Lightning Experience
Available in: All Editions

For details about using the functions included in these samples, see Formula and Operator Functions.

Expense Identifier

This formula displays the text Expense- followed by trip name and the expense number. This is a text formula field that uses an expense number custom field.

1"Expense-" &
2                    Trip_Name__c & "-" & ExpenseNum__c

Mileage Calculation

This formula calculates mileage expenses for visiting a customer site at 35 cents a mile.

1Miles_Driven__c * 0.35