^In List^ RI_FILTER

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Shaughn_(Guest)
Posts: 17
Joined: Tue Oct 10, 2017 12:44 pm

^In List^ RI_FILTER

Post by Shaughn_(Guest) » Fri Jul 23, 2004 10:20 am

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,

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: ^In List^ RI_FILTER

Post by kfleming » Fri Jul 23, 2004 2:53 pm

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

Post Reply