Hello experts,
I need to calculate a rather strange average for period May-October. Our payroll is quincenal meaning 15 days.
For people with complete period there is no problem. I have problems with average for people with entry in this period.
For example> person entry 25 Jun. For average calculation I need to take the salary for the whole period of 15 days starting with 15 Jun even if person worked only 6 days in Jun.
What is the best way to do this calculation?
Thank you all.