adding sum of the billed hours in the past two weeks hours into a task report?

[AlCa]

I have a task report that shows projects where the `actual hours` exceed the `planned hours`. I would like to add another column that shows the total billed hours in the past two weeks (or perhaps some other interval).. so far I haven't been able to figure it out. I've tried to create a calculation field on a custom form but that does not give me access to the Hours fields. Front line support from workfront suggests I can't do this in a Task report (it would have to be an hours report) but then says It's possible that there might be an advanced text mode that would be able to provide you with that data. For this type of request, it would be best for you to reach out to Remote Consulting. My preliminary look at an hours report indicates that this is *not* the right direction. I have in inkling that my only option would be a text mode column with some filtering and aggregating... Can anyone point me in the right direction? Or perhaps crush my dreams? Thx Al Al Caughey Design 1st Inc.

[VicAl]

I'm not familiar with the Billed Hours field. Is it something you created or is it a WF field. I can only find Billed Revenue in the WF fields. But either way, if it's a WF field or a field you created you should certainly be able to do the calculation or display of the field. So your dream is still alive ... for now �� Are you using a Matrix Report or something to display the columns? Vic Alejandro, PMP, CSM | IT | Sr. IT Project Manager Denver Water | t: (303-628-7262) | c: (303-319-6473) "http://www.denverwater.org/"> http://www.denverwater.org INTEGRITY | VISION | PASSION | EXCELLENCE | RESPECT