Custom Column for Total Hours or Days in the Reporting Period

  • 1
  • Idea
  • Updated 3 years ago
  • Not Planned
I am trying to create a custom column and need the total number of work days (or hours) in the reporting period Entry Date.  For example, if I run the report where Entry Date = Last Week it would show 5.  If Entry Date = Previous Month, it would show something like 22 days.  If I select a custom period, for ex: Dec 3 -6 it would show 2 days. 

I've tried Week Days, Weekday Hours, & Work Days, but those only count days/hours when that specific project was used for that week.  

Any tips?
Photo of Green, Jordan

Green, Jordan

  • 10 Posts
  • 1 Reply Like

Posted 3 years ago

  • 1
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1522 Posts
  • 106 Reply Likes
Hi Jordan,

Thank you for using Replicon Community!

May we please confirm what are the other fields that you are trying to report on? Whether it is a time report or project status report.

Thanks,
Aashnee Kamboj
Photo of Green, Jordan

Green, Jordan

  • 10 Posts
  • 1 Reply Like
It is a Timesheet Day Template.  I am trying to run a report over a user-defined period of time that will show hours by project and billable percent (# hours on billable projects/work hrs in that period).  I do not want to use hours worked, but rather 8 hours per day * the number of days.
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1522 Posts
  • 106 Reply Likes
Hi Jordan,

We will have our Product Management team look into this.

Thanks,
Aashnee Kamboj
Photo of Charlene Eriksen

Charlene Eriksen, Product Manager

  • 347 Posts
  • 37 Reply Likes
Hi Jordan,

Unfortunately, I can't think of any way to achieve this currently. There are fields for # of work days in the timesheet period, but nothing dynamic based on the date filter. But we'll review this as an idea for future report improvements.

Thanks,
Charlene