Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
NSC | Using the GREATEST or LEAST Function to Shorten a long CASE WHEN Formula in a Saved Search
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
Learn how to Refer A Member | Earn the Answer Accepter Badge | Be the Content Creator of the Quarter | Vote for the content you want to see!