Column in a project report - total actual hours not including current month | Community
Skip to main content
L
LauraEr
February 27, 2025
Solved

Column in a project report - total actual hours not including current month

  • February 27, 2025
  • 3 replies
  • 530 views

Can anyone help with a column that is needed in one of our project reports? We would like to see how many actual hours were tracked to the project not including the current month (ex. project A has a total of 100 hours tracked to date, 20 in Dec, 20 in Jan, and 60 in Feb. We want that column to show 40 hours since those hours were tracked in Dec & Jan, not the current month of Feb). Hoping it can be done 🙂 Thanks in advance! 

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

Hi @lauraer - It is not possible to show 40 hours with calculated columns. Calculated columns can perform mathematical and text functions on fields, but they cannot filter records.

For your requirement, it is recommended to use Fusion to obtain 40 hours and store it in a custom field.

3 replies

_Manish_Singh
_Manish_SinghAccepted solution
Level 9
February 28, 2025

Hi @lauraer - It is not possible to show 40 hours with calculated columns. Calculated columns can perform mathematical and text functions on fields, but they cannot filter records.

For your requirement, it is recommended to use Fusion to obtain 40 hours and store it in a custom field.

    Doug_Den_Hoed__AtAppStore
    Community Advisor
    Doug_Den_Hoed__AtAppStoreCommunity Advisor
    Community Advisor
    February 28, 2025

     

    Hi @lauraer,

     

    In addition to the Fusion option @_manish_singh mentioned, another approach could be to create an Hour based Matrix Report that horizontally groups the actual hours by month, vertically groups them by Project, and filtered to include only those hours whose Entry Date is before $$TODAYbm (i.e. the beginning of the current month).

     

    If either approach solves your problem, fabulous; and for a related glimpse of where other Workfront Sponsors have asked us to take similar concepts, I invite you to consider our Capacity Charts solution which can overlay actual hours as a "thermometer" onto the planned stacked bars and dashed capacity line, and/or our AFA Burn List solution which provides a numerical grid of Approved vs Budget vs Actual Hours (and costs) by project including the "Approved Remaining" calculations. I'd be happy to chat further via doug.denhoed@atappstore.com.

     

    Regards,

    Doug

      KellieGardner
      Community Advisor
      KellieGardnerCommunity Advisor
      Community Advisor
      March 4, 2025

      Hi Laura - 

       

      As the others have mentioned, there isn't a real way to do this in reporting. Best solution would be to use the field "actual hours this month" and "Actual Hours"/"Total Hours" to view a comparison.

       

       

       

      Since actual hours last month at the project level isn't stored in the API as format that can be referenced in a calculation, it won't be usable in any other way than having it as it's own column in the report. 

       

      Additionally, you can run hours report and filter for entry date before this month and use the summary tab to see the sum by project. 

       

        Terms & ConditionsAccessibility statement

        Loading footer...