I ve tried `CASE WHEN whatevermyfieldis IS NULL THEN ELSE wh NetSuite Professionals #suiteanalytics

I’ve tried `CASE WHEN {whatevermyfieldis} IS NULL ...

jen

12/29/2020, 11:09 PM

I’ve tried

CASE WHEN {whatevermyfieldis} IS NULL THEN '' ELSE {whatevermyfieldis} END

12/29/2020, 11:36 PM

If you're grouping the search results try Minimum instead of Group

jen

12/29/2020, 11:38 PM

…?

jen

12/29/2020, 11:38 PM

that will give different, and wrong, results