Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Program report pulling number of Projects in Program

Avatar

Level 4

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?

4 Replies

Avatar

Level 3

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

Avatar

Level 4

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

Avatar

Level 4

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.

Avatar

Level 4

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