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!
NSC | Resolve Error: "There is a divide by zero error in this search..."
Scenario
A user is attempting to display the item rate field in a sales invoice saved search in NetSuite but is encountering issues due to the absence of a direct 'Rate' field and encounters error when attempting to derive this using a formula instead. The user encounters the error, "There is a divide by zero error in this search. It may be an error with a formula you have used. Please retry without the formula(s)…"
Solution
To display the item rate in a saved search, use a formula to calculate the rate by dividing the amount by the quantity. However, to avoid errors caused by division by zero, use the following approach:
Shiela Marie Villaluz | Ask a Guru
Earn Community badges now! Refer a Member | Answer Accepter |