Gareth Horton
July 12th, 2002, 12:21 PM
Nicholas Osdale wrote:
> Joel Heyman wrote:
> > Nicholas Osdale wrote:
> > > I have the following Filter to show me where 5 State columns do not match each other:
> > >
> > > (IF(Home<>Work,1,,$s:LF> If(Home<>[W/C],1,,$s:LF> If(Home<>SUTA,1,,$s:LF> If(Home<>DBL,1,0))))=1)
> > >
> > > Is there a better way of doing this filter (ie another function I might be overlooking)?
> > >
> > How about using the NOTIN function - If(Home NOTIN ("Work","W/C","SUTA","DBL"), 1,0)
> Doesn't the In() and NotIn() functions check the Value of a field? Work,W/C,SUTA, and DBL are all Fields that contain a State Abbreviation. I need to make sure all 5 of these fields contain the same state.
>
not.(home=Work .and. home=W/C .and. home=SUTA .and. home=DBl)
should do it.
> Joel Heyman wrote:
> > Nicholas Osdale wrote:
> > > I have the following Filter to show me where 5 State columns do not match each other:
> > >
> > > (IF(Home<>Work,1,,$s:LF> If(Home<>[W/C],1,,$s:LF> If(Home<>SUTA,1,,$s:LF> If(Home<>DBL,1,0))))=1)
> > >
> > > Is there a better way of doing this filter (ie another function I might be overlooking)?
> > >
> > How about using the NOTIN function - If(Home NOTIN ("Work","W/C","SUTA","DBL"), 1,0)
> Doesn't the In() and NotIn() functions check the Value of a field? Work,W/C,SUTA, and DBL are all Fields that contain a State Abbreviation. I need to make sure all 5 of these fields contain the same state.
>
not.(home=Work .and. home=W/C .and. home=SUTA .and. home=DBl)
should do it.