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 statements in Saved Search results
Has anyone else had difficulty putting nested statements in the results of a Saved Search? We're trying to include a Case When inside of another Case When. Any alternatives would be very much appreciated.
Thank you!
example below:
CASE WHEN {CASE WHEN {custentity_original_slx_budget_hours}>0 THEN {custentity_original_slx_budget_hours}-{actualtime}-{custentity_legacy_billed_hours} ELSE {custentity_implementation_hours}+{custentity_training_hours}-{actualtime}}<0 THEN ‘0’ ELSE {CASE WHEN {custentity_original_slx_budget_hours}>0 THEN {custentity_original_slx_budget_hours}-{actualtime}-{custentity_legacy_billed_hours} ELSE {custentity_implementation_hours}+{custentity_training_hours}-{actualtime}} END