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 formula in saved search not functioning
Hello-
I am trying to calculate a commission amount on a sales order if a customer has a checkbox (a custom field in the customer record) selected or not.
I have the following case statement in the saved search and it always calculates to 0, even if the customer record has the checkbox selected.
CASE when ({customer.custentity_commission_account} ='Yes')
THEN {amount}*.03
ELSE {amount}*0
END
I have tried many variations evaluation for the checkbox (yes, "yes", 'Yes', 1,"1",'1', true, TRUE,....) and none seem to work.
I did get it to always calculate the {amount}*.03 if I evaluated the expression to IS NOT NULL.