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

For a field with a formula set is it possible to do a if statement?

```if {someField} != 0:
    do this
else:
   do something else```

`CASE WHEN {somefield} != 0 THEN ... ELSE ... END`

<@U29QCJQF3> Do you know if it is possible to do nested cases?

<@UHQFWH30Q>, yes you can. e.g:

```CASE WHEN {somefield} != 0 THEN
    CASE WHEN {somefield} &gt; 0 THEN 'positive' ELSE 'negative' END
ELSE 'zero' END```

This formula thing would be sooo much easier if you could just write it in SS vs. SQL