Total of current salaries
Hi, I have an issue with a calculation I want to make. Let me explain.
I have a table 'Staff' with all the employees. Under each Record I have a DateJoined and a DateLeft (empty if currently employed). I also have a MonthlySalary field and a LastIncreaseDate and LastIncreaseAmount.
What I am trying to do on a Summary layout is to have the total salary paid per employee, and grand total, for the Current date. Where I get a bit confused is that there are a lot of parameters:
- if the employee joined after Jan 1st,
- if the employee left during the year
- if there is a salary increase during the year
All help will be welcomed!