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 Statement Issues with multiple WHEN arguments fail
I've been trying every different conceivable construct for a CASE statement in a Saved Search, yet every time I include more than one WHEN argument I get the dreaded "ERROR: Invalid Expression". The statement is looking to see what the "Survey Type" is and based on that value it should return the value from the different related fields. All of the potential return expressions are different fields yet they can only contain the value 1 to 7.
I created these as Formula(Numeric) saved search fields.
Here was my first attempt.
CASE {custrecord_his_svcssurv_survey_type}
WHEN 'PS TS Project Kickoff Survey' THEN TO_NUMBER({custrecord_his_svcs_surv_projectoutlined})