InfoPath Dev

I have a secondary data source for a Weekly Summary Report. The users are required to submit weekly. I want to be able to return the users who don't exist in that weeks query. To display in calculated value of "User who didn't submit". I used this - substring(xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Weekly Summary Report")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Author/pc:Person/pc:DisplayName[. != xdXDocument:GetDOM("AccMgrs")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Name], 'concat(";", " ", .)'), ".."), 2) . This returns all the names vs just the names that don't exist. To sum it up I want to compare the list of submitted "Weekly Summary Report" to "AccMgrs" which is the list of all the names. Hoping someone can pick this apart and help.

Hi ldkud,

So to clarify, you want to list all of the people in AccMgrs who are not in Weekly Summary Report.  Is that right?  If so, I think this might work:

substring(xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("AccMgrs")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Name[not(. = xdXDocument:GetDOM("Weekly Summary Report")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Author/pc:Person/pc:DisplayName)], 'concat(";", " ", .)'), ".."), 2)

Jimmy you are the man! Worked perfectly... Thank you.