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!
Simple Formula Field / Issues
Issue #1
I am trying to complete what I thought would be a very simple task. Basically, I am running an Inventory Report for a customer that they will then upload into their system. Due to constraints on their end, I need to populate blank fields with a 0. That is, if an item is not in stock and is blank, I need it to say 0 instead.
I did a Formula (numeric) field in my Item Search:
CASE WHEN {quantityavailable}is null THEN '0' ELSE {quantityavailable} END
I keep getting an error citing ERROR:Invalid Expression.
What am I doing wrong!?