the opposit if this formula case when {item} like '%SALT%' then 1 when {item} like '%SKID%' then 1 else 0 end is not 1

AI generated answer (using internal Slack threads):

The opposite of the formula

case when {item} like '%SALT%' then 1 when {item} like '%SKID%' then 1 else 0 end

would be a formula that returns 1 when the

{item}

does not contain 'SALT' or 'SKID' and 0 otherwise. Here is how you can write it:

sql
CASE 
  WHEN {item} NOT LIKE '%SALT%' AND {item} NOT LIKE '%SKID%' THEN 1 
  ELSE 0 
END

This formula will return 1 when

{item}

does not contain 'SALT' or 'SKID', and 0 otherwise. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******