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

Any insight in creating a CASE WHEN formula and the field I am trying to dictate the formula on is not always present on a line item?
`CASE WHEN {field} is not present THEN x ELSE y END`
IS NULL doesn't work,  IS '' doesn't work. NVL threw error.

are x and y of different types? you might need to convert

`CASE WHEN {custcol_ns_acs_track_img_url} = NULL THEN '' ELSE '&lt;img src="'||{custcol_ns_acs_track_img_url}||'" width="100" height="100"&gt;' END`

the case when field is simply an ACS line item field with a url which may or may not be present.

You should be using IS NULL rather than = NULL
Does the formula return errors if you just go
```CASE WHEN {custcol_ns_acs_track_img_url} IS NULL THEN '' ELSE {custcol_ns_acs_track_img_url} END```
?

No errors. I also get no errors if it is simply that field.