Project Report Calculated Field Change from Home Team to Other Team

[MichelleFr2]

I need help changing this calculated field (on a Project Report) from pulling the Project Owners Home team to Project Owners Other Team ID:

owner:homeTeamID=

owner:homeTeamID_Mod=in

[ChristinaJay]

did you try owner:teamID=?

[MichelleFr2]

yes and I get this error

[Kurt_Jones]

Michelle,

You can't get to that info via a calculated field, however, on a project report you should be able to search in the column for Owner->Other Groups and that will provide you the other groups the owner is in.  Once found, if you put that field in textmode it looks like below:

viewalias=owner:otherGroupsNames
linkedname=owner
namekey=view.relatedcolumn
namekeyargkey.0=owner
namekeyargkey.1=otherGroupsNames
valueformat=HTML
tile.name=component.othergroups.names