Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Community Advisor

01-06-2020

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.