Scenario
At a saved search, user encounters an 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). If an error still occurs, please file with Customer Support. If it does not, please correct your formula. Typically that consists of taking the denominator and wrapping it in NULLIF (<denominator>,0).
Solution
The error is attributed to a formula that returns zero value on results. To resolve this, user need to convert a value to "NULL" instead of "0" where the mathematical operation fails.
- Navigate to Lists > Search > Saved Searches
- Click Edit on existing Transaction Saved Search
- Click Results
- Click Columns
-
Field:
Note: Always click Add once Field is selected and adjust as needed.- Formula: Enter {quantityshiprecv}/NULLIF({quantity},0)
Note: This is just a sample formula using the NULLIF function.
- Formula: Enter {quantityshiprecv}/NULLIF({quantity},0)
- Click Save & Run