Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Need to create a report filter where Project Group doesn't match the Portfolio Group

Avatar

Level 4

Does anyone know how/if I can create a filter on a report that would show me only projects who's group (groupID) does not match the group for the portfolio (portfolio:groupID) the project is part of?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Here's your filter:

portfolio:groupID=FIELD:groupID
portfolio:groupID_Mod=ne

Here's your Portfolio Group Name column:

displayname=Folio Group
linkedname=portfolio
namekey=view.relatedcolumn
namekeyargkey.0=portfolio
namekeyargkey.1=group:name
querysort=portfolio:group:name
textmode=true
valuefield=portfolio:group:name
valueformat=HTML

 

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Here's your filter:

portfolio:groupID=FIELD:groupID
portfolio:groupID_Mod=ne

Here's your Portfolio Group Name column:

displayname=Folio Group
linkedname=portfolio
namekey=view.relatedcolumn
namekeyargkey.0=portfolio
namekeyargkey.1=group:name
querysort=portfolio:group:name
textmode=true
valuefield=portfolio:group:name
valueformat=HTML

 

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.