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

Hi, what is the correct saved search syntax for 'IS NOT'? I'm trying to filter only those opportunities where status IS NOT ‘Closed - Lost ‘ OR ‘Closed - Won’. Thanks!

What about -None Of- ? Choose the status which you don't want to see and keep the ones you wrote above

Hi <@U01R6610PMH>, I'm trying to achieve it via Formula (Numeric) as I also want to capture other opps on other fields.

case {field} when 'result 1' then 1 when 'result 2' then 1 else 0 end

Hi Kevin, I tried the one below but no luck. I think IS NOT is not a valid expression, rigt?

case when {type}= 'Opportunity' and {status} IS NOT 'Closed - Lost' then 1 when {status} IS NOT 'Closed - Won' then 1 else 0 end

just say `=` and make the result something you would exclude

decode({type},'Opportunity', case when {status} = 'Closed - Lost' then 1 else 0 end, case when {status} = 'Closed - Won' then 1 else 0 end)