How to add a column in the Programs view that shows # of projects?

[Justin_Charles]

The subject says it all.  Does anyone know how to add a column in the Programs view that shows how many projects are under each program?  I would want to filter out complete, dead, etc.

TIA!

[MattMc2]

Hi Justin, 

If you just need the project count it would be easier to create a project report and group by program. This will allow you to: (a) get a count of projects by program, and (b) create a bar chart to visually display the data.
- Matt

[Justin_Charles]

I'm hoping to target programs with 0 projects under them - this would not show up in a project report.

[skyehansen · Accepted solution]

I would recommend just using an exists statement in your filter in that case. Something like

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=PROJ

EXISTS:a:programID=FIELD:ID

[KellieGardner]

Hi Justin - you can't count a collection unfortunately but you can list the projects if that helps your scenario in anyway. 

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

I believe it's possible to count and return a value to a custom field on a program custom form if you have Fusion.