netsuite Exploiting formula columns in saved searches Count records with with and without a value provided in a field (count missing and non-missing values)
Example
Using Oracle SQL’s NVL2() function, you can create a display column which contains one value if a field contains data and another value if a field does not contain data. For example, in an Entity search, turn the presence of a primary e-mail address into a text display column:
NVL2( {email} , 'YES' , 'NO' )
This lets you count records subtotaled by the presence or absence of an email address:
Field: Internal ID
Summary Type: Count
Field: Formula (Text)
Summary Type: Group
Formula: NVL2( {email} , 'YES' , 'NO' )
