Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Joshua Mack

Recommended Posts

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'

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...