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!
CASE WHEN formula question
How can I do a nested Case When statement for a saved search? In other words:
If A or B then 1 else if C or D then 2 else if E or F then 3
More specifically:
case when {entitystatus}='A' or {entitystatus}='B' then 1 else case when {entitystatus}='C' or {entitystatus}='D' then 2 else case when {entitystatus}='E' or {entitystatus}='F' then 3 end
I can't seem to get the correct combination of using parenthesis, CASE WHEN, ELSE CASE WHEN. Is there a better way to do this?
Thanks!
Derek