Can I do range from-to to create a row in the financial report builder? Only following are available. Is, is empty, starts with, contains, is not, is not empty, does not start with, does not contain

AI generated answer (using internal Slack threads):

Based on the conversations provided, it appears that the functionality to create a row in the financial report builder using a range from-to is not directly available with the standard options provided in NetSuite. The standard options available are: Is, is empty, starts with, contains, is not, is not empty, does not start with, does not contain. However, there are a few potential workarounds that were discussed: 1. Using a formula condition with the REGEXP_LIKE function. An example provided was

CASE WHEN REGEXP_LIKE({name}, '^[0-9]*$') THEN 1 ELSE 0 END

. This formula checks if the name starts with a number from 0-9. 2. Creating a custom segment might help, but it won't be available in all reports like the Budget vs. Actual. 3. Using NetSuite Analytics or Workbooks as an alternative to create the desired report. 4. Creating an Item search and joining the Transactions. This approach was suggested in the context of creating a report/saved search to show quantity sold and quantity on hand with a given range of date, including items showing zero even if they are not sold during that specific timeframe. Remember, these are potential workarounds and may not fully meet your requirements. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******