Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Not in List Variable

Status
Not open for further replies.

blondie1999

Technical User
May 27, 2009
1
GB
Any help with this query would be greatly appreciated. I have created a report to summarise data which combines two other reports. Unfortunately, there are different conditions attached to each block in the other reports and therefore there is a conflict when I pulled both count totals together in the summary. The two reports are pulled in from different universes aswell. My option is to create a count variable which will include or exclude fields. The Inlist function works fine but I am having problems with the Not In List equivalent. There is an operator called Not but I get errors when I use this. Any suggestions how to exclude data in variables? Looking forward to your responses and if you could include a working example that would be fantastic.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top