Is it possible to add "is empty" or "none" selection in a financial report filter? So when used, the results would be filtered so that result is showing only if the field is empty

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that it is possible to add "is empty" or "none" selection in a financial report filter in NetSuite. For a list/record field, you can use a formula in the criteria such as

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

is equal to 1. This will return the records where the field is empty. For a date field, you can use a date formula in the criteria. However, it's important to note that if you need to add this to the filters area, it will be locked into whatever selection you have. This may not work if your use case is to be able to swap back and forth easily between 'empty' and other criteria like 'on a specific date'. In the case of financial reports, you can set up the filter and adjust it. When setting up the filter, check the box to show up in the filter region. After running the report, click 'more' at the bottom of the report to get the filters to show up. You can also set the filter without selection so it defaults that way when the report runs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******