^In List^ RI_FILTER
-
- Posts: 17
- Joined: Tue Oct 10, 2017 12:44 pm
^In List^ RI_FILTER
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
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