AnsweredAssumed Answered

Total of current salaries

Question asked by thezed on Jul 7, 2009
Latest reply on Jul 9, 2009 by thezed

Title

Total of current salaries

Post

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!

Z. 

Outcomes