Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

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.