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

[LauraEr]

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! 

[_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.

[Doug_Den_Hoed__AtAppStore]

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]

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.