Time Off Reporting Should Reflect User's Schedule's Exception and not Default Schedule's Exceptions | Community
Skip to main content
MoniqueEvans
Community Advisor
Community Advisor
June 1, 2020
New

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

  • June 1, 2020
  • 0 replies
  • 240 views

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.