Report to show programs where all projects are completed

Question

Hi WF Community,
 
I'm trying to figure out how to create a report - that will be part of a dashboard added as a custom tab at the portfolio level - whereby we can surface only programs where all of the projects with them have either project Status of "Complete" or "Scoping Archived".I would I need to leverage EXISTS filtering in my report?  Anyone able to provide some guideance or an example?Thanks,Nick

Richard_Le_ · Accepted Answer

Hey Nick,

I've been having a play around with this and I believe that the below EXISTS statement should do it:

EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=PROJ
EXISTS:a:programID=FIELD:ID
EXISTS:a:status=CPL
EXISTS:a:status_Mod=in
AND:1:EXISTS:a:$$EXISTSMOD=NOTEXISTS
AND:1:EXISTS:a:$$OBJCODE=PROJ
AND:1:EXISTS:a:programID=FIELD:ID
AND:1:EXISTS:a:status=DED	PLN	CUR
AND:1:EXISTS:a:status_Mod=in

This code is effectively telling Workfront, show me all programs that contain projects in a complete status AND where there are no projects in a Dead, Planning or Current state.

You'd obviously need to tweak this to your own requirements adding the status code for "Scoping Archived" to the EXISTS statement, and any other statuses you need to exluded to the NOTEXISTS statement . . .but hopefully that gets you somewhere close to what you need.

Let me know how you get on.

Regards,

Rich.

Sign up

Login with SSO

Login to the community

Login with SSO