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!
Nested Case Statements
Hi there,
I'm trying to do this:
CASE WHEN {custrecord104.custrecord127} = '1'
THEN
CASE
WHEN {custrecordf} = 'No' THEN 'Requires Attention'
WHEN {custrecord136} = 'No' THEN 'Requires Attention'
WHEN {custrecord136} IS NULL THEN 'Requires Attention'
WHEN {custrecord75} = 'No' THEN 'Requires Attention'
ELSE 'OK'
END
END
CASE WHEN {custrecord104.custrecord127} = '0'
THEN
CASE
WHEN {custrecord136} IS NULL THEN 'Requires Attention'
WHEN {custrecord75} = 'No' THEN 'Requires Attention'
ELSE 'OK'
END
END
In one formula field but it isn't working. What's the correct way to do it?