Comparing one field against another in a filter

[HarryWi1]

Hi Our general practise for Program managers is to become the project owner, until there is a Project Manager available to be allocated. I need to create a report to show me projects where the owner of the project and program are the same. This is a project report. I have previously got Field comparison filters working, but for some reason this one has got me stumped. My current filter (keeping it simple for testing): program:ownerID=FIELD:ownerID program:ownerID_Mod=in Any help is greatly appreciated. Thanks Harry

[TerryHy]

Hi Harry, try this...add project: before ownerID in your second line. I just tested this out on my end, and I got a list of projects where Project Owner = Program Owner. program:ownerID=FIELD:ownerID program: project: ownerID_Mod=in Terry Hynd EBSCO Information Services

[HarryWi1]

The logic behind that is baffling me but it darn well works! :) Thanks Harry Wigley ENT