6

I'm trying to use a formula to get a field populated with the word "false" in NetSuite, but currently when I use this I get nothing showing up. If I modify it slightly to say "null" or "blank" or leave it as just a space, it returns an error.

The code I'm using is 

CASE WHEN {custitem_upc_number} = 'null' THEN 'FALSE' END
Jdg50
  • 448
  • 2
  • 9
  • 18
user2793912
  • 61
  • 1
  • 1
  • 2

1 Answers1

16

Try

CASE WHEN {custitem_upc_number} is NULL THEN 'FALSE' END

Also, for NetSuite Null check related formulas - give NVL and NVL2 a try

Syntax :

NVL({expression1}, {expression2})

NVL2({expression1}, {expression2}, {expression3})

Nitish
  • 776
  • 3
  • 13
  • @user2793912 can you give some more details about the thing that you are trying – Nitish Sep 19 '13 at 06:18
  • I can identify blanks in some fields with `=''` (equals two single quotes) but others fail with that method. `IS NULL` did the trick for me! – ChrisB Apr 10 '18 at 18:51