Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Which report type is recommended to collect Total Planned Hours in each portfolio w.r.t. year?

Avatar

Level 9

Hi,

Looking for recommendation "Which report type is recommended to collect Total Planned Hours in each portfolio w.r.t. year?"

Mvh

Kundan.

Topics

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

1 Reply

Avatar

Level 7

Hi Kundan,

I have done this in a project report previously and group by Portfolio and project name.

Here's the textmode code for Planned Hours with the aggregator added to show the sum in the header:

aggregator.displayformat=minutesAsHoursString

aggregator.function=SUM

aggregator.namekey=workrequired

aggregator.valuefield=workRequired

aggregator.valueformat=compound

displayname=

linkedname=direct

namekey=workrequired

querysort=workRequired

valuefield=workRequired

valueformat=compound

viewalias=workrequired

Once you add this column to the report you can then filter on projects that either start or end within the calendar year.

Hope this helps,

Teale