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!
Saved Search - Combine Multiple CASE WHEN ELSE statements
Hello,
I have reviewed the forum and suiteanswers and could not find suitable post. I would like to understand if Netsuite allows multiple case when else then statements to be combined in saved search results.
Example: Transaction search
Forumla (Text)
CASE WHEN {type} = 'A' and {category} = 'MISC' then 'AAA' else 'ZZZ'
CASE WHEN {type} = 'B' and {category} = 'OTHER' then 'BBB' else 'YYY'
CASE WHEN {type} = 'C' and {category} = 'Internal' then 'CCC' else 'DDD'
Appreciate feedback.
Thank you