'Netsuite Formula - "blank" or "null" field

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
caseformulanetsuite


Solution 1:[1]

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})

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions