in a saved search how to you sort by a field but have the null or blanks show up first?

AI generated answer (using internal Slack threads):

In NetSuite, when you sort a saved search by a field, the null or blank values typically show up at the end of the list. However, if you want the null or blank values to show up first, you can create a custom formula field in your saved search. Here's how you can do it: 1. Go to your saved search and click on the 'Results' subtab. 2. Click on 'New Field' and select 'Formula (Text)' as the type. 3. In the formula field, enter a formula like this:

CASE WHEN {yourField} IS NULL THEN 0 ELSE 1 END

. Replace

{yourField}

with the actual field you want to sort by. 4. Give your formula field a label. 5. In the 'Summary Type' dropdown, select 'Group'. 6. Check the 'Sort Descending' checkbox. 7. Click 'Save'. This formula will assign a value of 0 to null or blank fields and a value of 1 to non-null fields. When you sort by this formula field in descending order, the null or blank values (with a value of 0) will show up first. Remember to replace

{yourField}

with the actual field you want to sort by. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******