Infoassist: How to write an IF/AND/ELSE statement in the WHERE clause via advanced expression?

[Joshua Mack]

I attempted to write an expression to filter out some unit of measurements if one was true over the other but to no avail.

IF J001.FOLDER1.IQUOM EQ 'EA' 

 ELSE J001.FOLDER1.IQUOM NE 'IP', 'CS'

 IF J001.FOLDER1.IQUOM EQ 'IP'

 ELSE J001.FOLDER1.IQUOM NE 'EA', 'CS'

 IF J001.FOLDER1.IQUOM EQ 'CS'

 ELSE J001.FOLDER1.IQUOM NE 'EA', 'CS'

2nd attempt still no good

IF (J001.FOLDER1.IQUOM) EQ 'EA' THEN (J001.FOLDER1.IQUOM) NE 'IP' OR 'CS' AND 

 IF (J001.FOLDER1.IQUOM) EQ 'IP' THEN (J001.FOLDER1.IQUOM) NE 'EA' OR 'CS' AND 

 IF (J001.FOLDER1.IQUOM) EQ 'CS' THEN (J001.FOLDER1.IQUOM) NE 'IP' OR 'EA'

[Martin Yergeau]

An IF/ELSE statement must be written as per below syntax

IF AA EQ BB AND DD EQ EE THEN FFELSE IF GG EQ HH AND JJ EQ KK THEN LLELSE MM;

Where AA, BB, CC, DD, EE, FF, GG, HH, JJ, KK, LL & MM are fields or values to test.