Expand my Community achievements bar.

Actual Hours Last Quarter

Avatar

Level 6
Hey everyone! I'm trying to force something into a column using text mode and not having any luck. I can pick some pre-defined things: Project >> Actual Hours This Month Project >> Actual Hours Two Months Ago Project >> Actual Hours Last Three Months Instead, I want to make a Project >> Actual Hours Last Quarter, but its A) not pre-defined, and B) not working when I try the following in text mode: valuefield=actualHoursLastQuarter valuefield=actualHours($$TODAYb-1q)($$TODAYe-1q) I'm not sure how #2 should be formatted, but all my variations have failed so far. Any help here would be appreciated!! Thank you, Brian Brian C. Mauger Bloomberg L.P.
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10
Hi Brian, Since Actual Hours This Quarter (apparently) isn't available at the Project level, I'd suggest creating an Hour report (rather than a Project report), either as a list or a matrix, with a SUM on the Hours, grouped by Project (horizontally), and a filter where the Hour Entry Date is This Quarter, as explained in this >help article . Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads