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!
Complex Search Formula - too long for NetSuite
I have a hugely complex Search Formula that I now need to run some further comparisons on.
When I try to do this, I exceed the maximum field length for the Formula.
I was wondering if anyone had any suggestions on alternative ways of building the logic.
This is my current (working) formula (simplified for this post):
CASE WHEN ([complex formula here]) > 0 THEN ([complex formula here]) ELSE 0 END
Essentially, if the formula returns a negative value, I just want to give the result as 0
This is based on Invoice and Cash Sale transactions, but I now need to include Credit Memos and Cash Refunds (which will be genuinely negative values, but need to be excluded if they return a positive value).