Which report type is recommended to collect Total Planned Hours in each portfolio w.r.t. year? | Community
Skip to main content
Kundanism
Kundanism
Level 10
April 21, 2021
Question

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

  • April 21, 2021
  • 1 reply
  • 376 views

Hi,

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

Mvh

Kundan.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

T
TealeMcCleaf
Level 6
April 21, 2021

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

Terms & ConditionsAccessibility statement

Loading footer...