Divide by zero error
I created two calculated columns using case statement. Let's say column A and column B. Now the final calculation should be column B / (column A + column B)
When I run above calculation, it gives Divide by zero error. I also tried NULLIF function to eliminate this error but it is not working.
Did anyone face this error? Anyone has any solution to this?
Thanks for reaching out. Here is a post that might be helpful in your situation: https://stackoverflow.com/questions/861778/how-to-avoid-the-divide-by-zero-error-in-sql
Let me know if you have any further questions on this.Reply