Page 1 of 1

^In List^ RI_FILTER

Posted: Fri Jul 23, 2004 10:20 am
by Shaughn_(Guest)
Hello to all, I have a question, is there a way to use the ^IN THE LIST^ or ^NOT IN THE LIST^ in the RI_FILTER. I am using v8____Thanks,

=> RE: ^In List^ RI_FILTER

Posted: Fri Jul 23, 2004 2:53 pm
by kfleming
You use the inlist() function to do this.____To include only the New England states in a report, I could use:__INLIST(STATE,"ME","VT","NH","MA","RI","CT")>0____To exclude these states it would be:__INLIST(STATE,"ME","VT","NH","MA","RI","CT")=0____Kathleen__R&R Support