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

[Kundanism]

Hi,

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

Mvh

Kundan.

[TealeMcCleaf]

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