Forum Discussion
division by zero
KamilaOlek you can turn on feture to allow unrestricted measures in directquery which should then be able to use IFERROR function. You can go to File -> Options and settings -> DirectQuery.
What about just a simple IF statement?
=IF([QuantityKG] = 0,0,DIVIDE([NetValue],[QuantityKG])
You can also use DIVIDE function, probably a little cleaner:
=DIVIDE([NetValue],[QuantityKG],0)
DIVIDE will return the 3rd parameter as the value if a divide by zero occurs.
The division by zero is uniquely and reasonably determined as 1/0=0/0=z/0=0 in the natural extensions of fractions. We have to change our basic ideas for our space and world:
http://www.scirp.org/journal/alamt http://dx.doi.org/10.4236/alamt.2016.62007
http://www.ijapm.org/show-63-504-1.html
http://www.diogenes.bg/ijam/contents/2014-27-2/9/9.pdf
http://okmr.yamatoblog.net/division%20by%20zero/announcement%20326-%20the%20divi
Announcement 326: The division by zero z/0=0z/0=0 - its impact to human beings through education and research