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!
Need formula help in saved search
trying to add a numeric formula into a saved search to generate results that save manual calculation time. i am trying to put in a formula that divides the reference field by a set number if the reference is greater than 0. The reference field will either be blank or have a numeric value in it. here is the formula i have entered and i keep getting an error message that says invalid expression:
CASE WHEN {custbody_cbms} > '0' THEN ({custbody_cbms}/2.27) END
Any help on how to get this done would be greatly appreciated.
thanks!