Useful 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
Overview of Using Date and Date/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 Metrics Formulas
Sample Opportunity Management Formulas
Sample Pricing Formulas
Sample Scoring Calculations Formulas
Formula Operators and Functions Overview
PDF

Newer Version Available

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

Sample Expense Tracking Formulas

Available in: All Editions

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

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