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!
SQL Question - Can I get a formula to return a value of 0 rather than a negative.
Hello,
I want this formula to return a value of 0 if the sum is a negative number. Essentially, if fulfillments are greater than receipts in the time period, rather than return a negative number I'd like a zero. Is this possible? I've been struggling with this for hours.
CASE WHEN DECODE({inventorylocation},{transaction.locationnohierarchy},1)= 1 AND ROUND({today}-{transaction.trandate}) BETWEEN 60 AND 120 THEN {transaction.quantity} *-1 ELSE 0 END
Thank you!
Jackie