This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

<@UKW3MKAUC> one thing it looks like you are missing an OR before {memo} LIKE '%z%', but you can simplify this formula a lot using nested conditions

CASE WHEN {memo} LIKE '%x%' OR {memo} LIKE '%y%' OR {memo} LIKE '%z%' 
  THEN DECODE({postingperiod}, 'Jan 2019', '1', '2')
  ELSE DECODE({postingperiod}, 'Jan 2019', '3', '4')
END