Program report pulling number of Projects in Program

Forum|Forum|3 years ago
August 10, 2022
2 replies
1034 views

I have been trying to figure out how to create a Program report that pulls the number of Projects. I have found how to filter to show empty Programs but I can't find a way to pull the number of Projects in a Program. Does anyone have the text mode for how to pull that?

Workfront

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

Kurt_Jones

Community Advisor

Maura, this will give you the listing of projects underneath each Program, I think that is what you were looking for. I'm not sure you can just get a sum (number) of this or if so I'm not sure how to do it 😞

displayname=Projects
listdelimiter=<p>
listmethod=nested(projects).lists
textmode=true
type=iterate
valuefield=name
valueformat=HTML

M

maura-kAuthor

Level 3

That worked for my use case, probably even better than just giving me a number too! Thanks for the help!!

J

J_Hobbs

Level 3

That code is quite handy and should be built into the tool based on it being relevant and useful data to include when looking at Programs.

S

Stacey_Robertson

Level 5

I'm not sure if you use fusion - I have fusion count the projects under each portfolio or program and add it to a field on our custom form and then we can report on that number.