Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and 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.
0