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 doesn't work in saved search
I create a new saved transaction search type : item fulfillment. Then I want a calculate the total from sales order
- the rate in Sales Order. I use the formula(numeric) is CASE WHEN {createdfrom.quantity} != 0 THEN {createdfrom.amount} / {createdfrom.quantity} ELSE 0 END. » It does work when I preview, It show 0
- the amount in Item Fulfillment. I use the formula(numeric) is CASE WHEN {createdfrom.quantity} != 0 THEN ({createdfrom.amount} / {createdfrom.quantity}) * {quantity} ELSE 0 END » It does work when I preview, It show 0
Please everyone guide me how to use a work formula. Thank you