Skip to main content
RathinaGopalan
Level 2
May 6, 2024 6:55 AM UTC
Solved

Calculate the remaining hours of incomplete tasks

I want to calculate the sum of remaining hours of incomplete tasks inside project level custom form. Let me know if someone can help with this.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Richard_Le_
Richard_Le_Accepted solution
Community Advisor
May 7, 2024 8:42 AM UTC

Hi,

 

It's not going to be possible to sum the hours of incomplete tasks at the project form level. You could work out the difference between planned and actual hours across the entire project, but this wont exclude completed tasks.

 

Your best bet here is to create a task report, filtered to incomplete tasks and grouped by project. You could then sum the planned hours, gicing you the sum of the remaining hours to complete.

 

Best Regards,

Rich.

 

View in thread

1 reply

Richard_Le_
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
May 7, 2024 8:42 AM UTC

Hi,

 

It's not going to be possible to sum the hours of incomplete tasks at the project form level. You could work out the difference between planned and actual hours across the entire project, but this wont exclude completed tasks.

 

Your best bet here is to create a task report, filtered to incomplete tasks and grouped by project. You could then sum the planned hours, gicing you the sum of the remaining hours to complete.

 

Best Regards,

Rich.

 

Translate
Terms & ConditionsAccessibility statement

Loading footer...