My query works fine for a month and when I try to add few more months I am getting this error "ORA-01476: divisor is equal to zero"
Could you please let me know your thoughts on this ?
I had the same issue earlier, I finally find out the divisor is '0' or the output count is null or no records.
In the above scenarios, it's throwing an error.
The suggestion is to use a trick or logic to replace the null or zero value with the appropriate number.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...