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!
Using the Result of a Case Statement
I have a search that has the following Case statement as one of the result fields:
CASE WHEN (({accounttype}='Income') AND ({debitamount}>0)) THEN -{debitamount} WHEN (({accounttype}='Cost of Goods Sold') AND ({creditamount}>0)) THEN NULL ELSE {creditamount} END
How can I use the result of this Case statement in a script using .getValue.
Obviously the parameter required for .getValue is the field name, however when using the result of a case statement this isn't possible.
thanks