While creating a saved search in Netsuite, you want encounter a situation where you want have to display a value depending on some conditions. Such scenarios can be implemented by using sql CASE syntax in the formula field. For eg, in a transaction search, if you want to display a value depending on the transaction type, then you can add a formula text field in coulmn and use CASE as given below:

CASE WHEN {type}=’Invoice’ THEN ‘0’
WHEN {type}=’Journal’ THEN {status}
 ELSE ” END

The above field will display 0 when type is Invoice. It will display status of the transaction when type is Journal and for other transaction type, it will be blank.

NETSUITE ACADEMY