Jump to content

Need CF Help on Salary Increase


bleapy
 Share

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

Link to comment
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.

Link to comment
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.