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.
Click Save & Run