NetSuite Saved Search Formulas for Nulls and Zero Denominators
Handle a null in a NetSuite saved-search formula according to what the missing value means. Use a supported expression to prevent invalid arithmetic, then keep a separate indicator for incomplete data. Replacing every blank with zero can …
Read article: NetSuite Saved Search Formulas for Nulls and Zero Denominators