Pull remaining Planned Hours on Project Report | Community
Skip to main content
K
Kasey-Gagne
Level 5
April 11, 2025
Question

Pull remaining Planned Hours on Project Report

  • April 11, 2025
  • 3 replies
  • 801 views

I am looking to pull a project report that shows the total remaining hours on a project for tasks that have not yet been completed. I was playing around with Completed Hours but that doesn't seem to solve it. Anyone else doing something similar?

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

3 replies

Lyndsy-Denk
Community Advisor
Lyndsy-DenkCommunity Advisor
Community Advisor
April 11, 2025

Hi, Kasey. I think you'll be better served by a task report. There might be a way to gather a collection of task hours in a project report, but a task report is going to be closer to the data you need.

    K
    Kasey-GagneAuthor
    Level 5
    April 11, 2025

    Thank you for the quick response! The issue is that we need to have this at a project report level that we show to our exec leadership team. They do not want to see things at a more granular level (tasks). The hope was to show projects with there % complete and the remaining hours left to be completed on the project rather than only being able to show the total Planned Hours or Completed Hours. 

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    April 11, 2025

     

    Hi @kasey-gagne,

     

    Although it might be more than you need, I invite you to consider our AFA Burn List solution which tracks Rates, Hours and Hour Costs at the Total, Portfolio, Program, and Project level.

     

    In particular, the far-right section of this screenshot shows the Remaining Approved Hours, Hours Cost, and Cost %; and if Costs are not (yet) important to you, we could tailor a version for you that removes the Cost columns and instead includes columns for:

     

    • Project % Complete
    • Forecast Hours %,
    • Scope Creep Hours
    • Scope Creep Hours %
    • Actual Hours %
    • Remaining Hours $
    • Actual Hours % minus Project % Complete
    • Actual Hours % / Project % Complete

     

    If you think this might be a fit, I'd be happy to chat further via doug.denhoed@atappstore.com

     

    Regards,

    Doug 

      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      July 29, 2025

      @kasey-gagne Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

      Kautuk Sahni
      M
      MattLe3
      New Member
      August 1, 2025

      I'm trying to do something similar. I don't want to reinvent the wheel since I have an existing Issues report leadership really likes. On the report I can create columns for the resolve project original planned hours, planned hours, and actual hours. But if I ask the report to calculate the difference between planned hours and actual hours, I get nothing.  Basically - this doesn't work: {resolveProject:workRequired} - {resolveProject:actualWorkRequired} even though I have columns for each of those values separately... so the report can see that data... just can't do math? 

      Terms & ConditionsAccessibility statement

      Loading footer...