Need CF Help on Salary Increase

This topic is 2942 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi I need help in creating a custom function to calculate a salary increases based on the Starting Monthly Salary. Here's my scenario;

I have 2 Tables

Employee --< Employee Pay

The EMPLOYEE table will contain a Field with the Starting Salary; this will be the base value of the employee. Anytime the employee receives an increase, that will be added to the EMPLOYEE PAY table.  In our organization, increases can come as a Flat amount or at times a percentage increase.  Is it possible to create a Custom Function for this?

What I had in mind was to have a Increase Type field in the Employee Pay table, and depending on the selection.  Also, the calculation will be a sequential order by Effective Date of the increase.

I'm a Novice when dealing with complicated Calculations.

Any suggestions?

Thank

Share on other sites

Is it possible to create a Custom Function for this?

Possible, yes. Worthwhile? I doubt it. IMHO, it would be best for every salary change to lookup the previous salary's amount (either through a self-join relationship, or from a calculation field in the parent record) and calculate the resulting salary amount by applying the increase to the looked up value. The current salary would be simply the value of the resulting amount in the last record of salary changes. And the starting salary should be the first record in this table.

Share on other sites

This topic is 2942 days old. Please don't post here. Open a new topic instead.

Create an account

Register a new account

• Similar Content

• FileMaker Custom Function for HTML Entities

By HOnza,

• 1,619 views
• Custom Function Optimized to Evaluate Hundreds Times Faster

By HOnza,

• 1,082 views
• Marvelous Optimization #4 – Optimized Again

By HOnza,

• 2,875 views

By HOnza,

• 0 replies
• 550 views
• FileMaker Coaches' Corner - Tip 4 - Editable Popup Menu - Custom Function

By Richard Carlton,

• 0 replies
• 1,057 views
×
×
• Create New...