Expand my Community achievements bar.

Time Off Reporting Should Reflect User's Schedule's Exception and not Default Schedule's Exceptions

Avatar

Community Advisor

6/1/20

I created a wildcard report that calculates the number of days the individual has selected as time-off. To have a more accurate calculation I used the expression WORKMINUTESDIFF so that it would not include any days that are Schedule exceptions (aka holidays) since a lot of people will take off around an extended weekend. I noticed there were incorrect calculations for some of my users and after research discovered that WORKMINUTESDIFF only refers to the Default schedule instead of the user's schedule.


I wish there was an easier way to make a time-off report that did not involve so much text mode deciphering and could cleanly calculate John Smith has taken 10 PTO days this year.