Skip to main content

Formula for Salary calculation by FTE% (Workaround):

  • Sep 12, 2024 10:43 AM UTC
  • Sep 24, 2024 2:54 PM UTC
  • 2 replies
  • 137 views
  • Translate All

Bob calculated fields are still not available there isn't a field that calculates the salary based on the FTE%.

 

However, what you can use is a custom formula in one of your reports. For this, in your report click on the Column Picker, click on Manage Formulas, and Add a new one.

 

Type a name, and select Currency in the Output type.

Then, the formula should be the (FTE% * Base salary) /100. It should look like this:

(Employment - FTE % * Payroll - Base salary)/100

 

Save the formula, and add it in the Column Picker.

 

Then, the new column should appear and show you the calculated salary for the FTE%.

2 replies

Pedro

Thank you for the explanation but shouldn’t this calculation be: 

(Payroll - Base salary/Employment - FTE %)*100


Thanks
Tina

Translate

Hi ​@Tina Garrahie, in order for the outcome to be the value for the base salary according to FTE, we need to multiply the salary by FTE and divided by the full FTE (100%).

As an example, let’s say We want to calculate the true salary for someone that has a salary of 1000 euros and works 60% FTE.

 

We should calculate (1000*60)/100= 600 euros, 60% of 1000 will be exactly this outcome.

 

If we use the formula you suggested, (1000/60)*100= 1666. 1666 is more than the actual full base salary for this employee, so if the employee only works 60% of the time, this outcome is not correct.

 

Let me know if you need any further help ☺️

Translate