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!
Formula For a Custom Field on an Estimate Transaction
I am trying to build a CASE formula in order to populate another field on the Item Column Line. So far i have this:
CASE WHEN {quantity}-{custcolshipped}>0 THEN {quantity}-{custcolshipped}
[WHEN {quantity}-{custcolshipped}<=0 THEN “Completed”]
[ELSE “Error”]
END
I want it to subtract the total Shipped from the total Quantity ordered. If the value is greater than zero then it should return that value. If the value is Zero or a negative number it should return the word Completed. When i put this formula in it gives me Error: Invalid Expression.
Can someone please help me with this expression because I cannot figure out what is wrong! Thanks much.