How to create report calculating hours worked on holidays

  • 1
  • Problem
  • Updated 2 years ago
  • Acknowledged
I am having trouble creating a report that will calculate the hours worked on a holiday (for each user). In a "Timesheet Day" template report, I have created a custom column with the following formula:
IF(IsNull(TimeOffTypeName)=1,0,IF(TimeOffTypeName="Holiday",IF(IsNull(HoursWorked)=1,0,HoursWorked),0))
However, this does not work. I think because when our employees record their worked hours on a holiday, it is booked in a separate entry from the holiday hours on the same date. Therefore, HoursWorked is always 0 for the holiday entry (while there are still HoursWorked on a separate entry for the same date.)
Thank you for any guidance.

Photo of Ben PS

Ben PS

  • 2 Posts
  • 1 Reply Like

Posted 2 years ago

  • 1
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1560 Posts
  • 108 Reply Likes
HI Ben,

Thank you for using the Replicon Community!

I would like to have a quick call with you. Can we schedule a call for discussing the issue

Thanks,
Aashnee