Program report pulling number of Projects in Program

Forum|Forum|3 years ago
August 10, 2022
2 replies
1026 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

S

Stacey_Robertson

New Participant

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.

M

maura-kAuthor

New Participant

Ohh we do have Fusion. That's a good idea - I can think of a few other things to with that too! Thanks!!

Kurt_Jones

New Participant

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