Program report pulling number of Projects in Program

5 replies
1033 views
Translate

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

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.

Translate

M

maura-kAuthor

Level 3

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

Translate

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

Translate