Report help: Planned hours remaining | Community
Skip to main content
Ross_Barton
Ross_Barton
Level 4
June 7, 2024

Report help: Planned hours remaining

  • June 7, 2024
  • 1 reply
  • 1613 views

We are trying to build a report to show:

  • Project name
  • Task name
  • Task planned start and end dates
  • Actual hour to date
  • Planned hours remaining <<< HOW DO WE DO THIS?

Normally, we calculate planned hours minus actual hours.

 

However, we only want future planned hours (those that have been resourced since the beginning of this week) without considering historical planned hours. 

 

Any suggestions on the calculation?

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
June 7, 2024

Hi, so you have a task report, I assume, and you want to show difference between actual hours logged on the tasks vs. planned hours. Is that correct?

If so, try adding a column to your report and enter this value expression in the column text mode:


displayname=Difference in Hours (or whatever you want to call it)
textmode=true
valueexpression=CONCAT(DIV(SUB({actualWorkRequired},{workRequired})/60)," Hours")
valueformat=HTML

If this helped you, please mark correct to help others : )
Ross_Barton
Ross_BartonAuthor
Level 4
June 7, 2024

Madalyn,

 

Close. We don't want to pull the total planned hours, only the future planned hours.

 

Essentially, it is a report that shows how much time has been spent to date and captured on timesheets (as of the last timesheet period) and how much future planned time – assigned time by day or whatever the system calls it – remains (starting in the current week). 

 

We want to see how many hours people have spent on the task and how many planned hours are projected in the future. To gage estimated effort of key tasks to compare between projects.

 

We cannot use the total planned hours based on how we resource which is why we cannot use total planned hours.

 

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
June 7, 2024

Hmm that's tricky bc that assumes you've been tracking against the planned hrs at a consistent rate, not sure how WF would know how many planned hrs are 'left' without looking at total planned hours.

Have you messed with the 'show remaining time' setting in the workload balancer? If you're looking to see which resource is best for the week based on avails, this could help? Sorry I'm not much help on this one.

 

If this helped you, please mark correct to help others : )
Terms & ConditionsAccessibility statement

Loading footer...