Sample Employee Services Formulas

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

Bonus Calculation

This example determines an employee's bonus amount based on the smallest of two amounts: the employee's gross times bonus percent or an equally divided amount of the company's performance amount among all employees. It assumes you have custom number field for Number of Employees, a custom percent field for Bonus Percent, and currency custom fields for the employee's Gross and company's Performance.

1MIN(Gross__c * Bonus_Percent__c, ​
2  Performance__c / Number_of_Employees__c)

Employee 401K

This example formula determines which amount to provide in employee 401K matching based on a matching program of half of the employee's contribution or $250, whichever is less. It assumes you have custom currency field for Contribution.

1MIN(250, Contribution__c /2)

Hours Worked Per Week

This formula uses a custom tab to enable time tracking of hours worked per day. It uses a formula field to sum the hours per week.

1MonHours__c + TuesHours__c + WedsHours__c + ThursHours__c + FriHours__c

Total Pay Amount

This formula determines total pay by calculating regular hours multiplied by a regular pay rate, plus overtime hours multiplied by an overtime pay rate.

1Total Pay = 
2IF(Total_Hours__c <= 40, Total_Hours__c * Hourly_Rate__c, 
340 * Hourly_Rate__c + 
4(Total_Hours__c - 40) * Overtime_Rate__c)