Hi,
I'm trying to create a report that shows the headcount by department on a monthly basis. The problem I'm encountering is that it doesn't include people in the calculation if they don't have an end date, i.e. they are permanent staff. I'd be grateful if someone could review the attached example and let me know how to amend or write a new formula that does what i'm trying to achieve?
If you have any queries just give me a shout.
Thanks in advance,
Snook
Bookmarks