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!
How do I do a multiple selection using CASE WHEN
I am writing a saved search to look at return authorizations. I want it to display all of them based on a date range. I know how to do everything but one tricky part.
We have a selection of description items that the people creating the RAs are supposed to use to explain the reason for return. there are 7 description items in all. I can get the criteria to find the return auths. What I need is a formula that will display the reason for return description item used or show none if someone failed to use one of the pre-made desc items. I am having trouble with the syntax for the CASE WHEN statement, if that is even the best way to go.