Saved Search Formula error "Notice: 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)"

Scenario

Adding Formula in Saved Search results to Notice:  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.

Solution

This error is thrown when there is a formula where the denominator is zero. This in turn will cause the result to be invalid.

To resolve this:

1. Edit the Search
   
   
2. Replace the formula denominator with: NULLIF({denominator},0
   
   Example: {custentity15}/ NULLIF({custentity19},0)
   
   
3. Click Save