Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
This is a really small problem. I am trying to filter out these below names and get all other names, hence i have put a <> (not) sign. But still i get all these names. What is the mistake here?
=if( SUBJECT_AREA <> 'Bop_Settlement'
or SUBJECT_AREA <> 'Conf_Dim'
or SUBJECT_AREA <> 'HODS_CTIX_DD'
or SUBJECT_AREA <> 'Reporting'
or SUBJECT_AREA <> 'WAR'
or SUBJECT_AREA <> 'WebTrends' or wildmatch(SUBJECT_AREA,'CODS*')=0,SUBJECT_AREA)
Thanks in advance!
Use "and" instead of "or".
Use "and" instead of "or".
Thanks so much!