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

am i putting the pieces in the right place?

for numerical comparisons I believe you skip the yellow highlighted 'expr' and put everything in the blue highlighted 'comparison_expr' section, so for your one line IF statement would look like: CASE WHEN rule sequence = 4 THEN "FP&amp;A Approved" ELSE "blank" END

If you had more comparisons then they each get their own WHEN  rule sequence = x THEN "return this" line

Refer to the difference between the text and numerical examples from the Case section in the SQL Expressions article in the Netsuite Help Center