Forum Discussion
Active payroll calculation
Hello everyone, I would like to know if you can help me with the following query. I have a constant number of people assigned to the area at the beginning of each year, let's take as an example 54, but with the passing of the months there are entries and departures of personnel I need then that somehow the calculation of these variations can be made month by month to present it graphically.
| Initial Workforce | Revenue | Outputs | Current employees | |
| January-2021 | 54 | 0 | 3 | 51 |
| February-2021 | 51 | 0 | 0 | 51 |
| March-2021 | 51 | 0 | 0 | 51 |
| April-2021 | 51 | 0 | 1 | 50 |
| May-2021 | 50 | 0 | 0 | 50 |
| June-2021 | 50 | 2 | 1 | 51 |
In advance I appreciate if you could help me and the attention provided.
Hi Syndicate_Admin ,
If this is the case with the raw data, you may consider using a line chart to reflect these changes.
If your raw data does not look like the above, please see if this helps.
HR Analytics - Active Employee, Hire and Terminati..Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
2 Replies
Hi Syndicate_Admin ,
If this is the case with the raw data, you may consider using a line chart to reflect these changes.
If your raw data does not look like the above, please see if this helps.
HR Analytics - Active Employee, Hire and Terminati..Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Thank you very much, what I was looking for was just the link you referred to me (HR Analytics - Active employee, hiring and termination.)
