Project report filter for does not contain certain resource pools

[NickVa1]

Hi WF Community,

I'm trying to create a report that will show me projects that don't contain certain resource pool field values.

I tried using 'cinotcontains' as my text mode modifier, as this value was not available as a modifier in standard (filtering) mode, but this isn't working as expected.

Anyone know where I might be going astray?

Thanks.

Nick

[SarahNa]

Hi Nick,

Would this work?

resourcePools:name=<value you don't want>

resourcePools:name_Mod=cinotcontains

[NickVa1]

Thanks, Sarah. This does work; however, do you know how I can add multiple values in the resourcePools:name=<value you don't want> section? For example, I want to see projects that don't have:

• Platform Dept.
• QA Dept.
• SolCon Dept.
• Creative Dept.

Thanks.

Nick

[SarahNa · Accepted solution]

Hey Nick,

You can add 'AND' statements for each one that you don't want:

resourcePools:name=<value you don't want>

resourcePools:name_Mod=cinotcontains

AND:1:resourcePools:name=<value you don't want 2>

AND:1:resourcePools:name_Mod=cinotcontains

AND:2:resourcePools:name=<value you don't want 3>

AND:2:resourcePools:name_Mod=cinotcontains

Good luck!

[NickVa1]

Thanks again, Sarah. This is super close.

It works when:

a) I don't have any of the resource pools specified added to a project, but it has a resource pool outside my list

b) It has all of the resource pools specified added to a project, AND any other resource pool outside my list too

It doesn't work properly when:

a) There are no resource pools on a project at all (blank resource pools)

b) There are some of my specified resource pools but not all of them. Scenarios like this projects don't show up in the report.

Any ideas?

[SarahNa]

Hey Nick - why don't we hop on a call? I should be around for the next hour or so - shoot me an e-mail at sarah.nau@dominiuminc.com and we can get this figured out 😊

[NickVa1]

Sarah is the best! Thanks for taking time to help me out. We have this report in a good place, I just need to tweek it slightly.