In NetSuite Saved Searches, there is a 1000 character limit per formula expression. This is documented in SuiteAnswers 8449 and 8450.
For example, you have a long complex formula similar to this logic:
CASE WHEN ([long complex formula here]) > 0 THEN ([long complex formula here]) ELSE 0 END
Using a long complex formula more than once can easily exceed this 1000 character limit.
Assuming that the long complex formula used more than once is exactly the same, then we can use the GREATEST function to simplify and use the complex formula only once.
Here's the logic:
GREATEST(0, ([long complex formula here]) )
With this, only the greater value between 0 and the calculated formula will show in the results.
Alternatively, if the needed result is the lesser value, then we can use the LEAST function.
Visit the links below for more information about these functions:
Disclaimer: The GREATEST and LEAST functions are not officially supported by NetSuite and is not listed in the SQL Expressions in SuiteAnswers 10101. Use these functions at your own discretion.
-----
If you find this information useful, let us know by reacting or commenting on this post!