I have a integer field where I calculate a percent based on two other fields. If they enter zero for both, the percent is blank rather than displaying as 0. Is there any work around for this?
(0/0)*100 = Blank
instead of
(0/0)*100 = 0
That is because you cannot divide by 0 in math. Add an if statement that should work. Like if(denominator is 0, 0 , else do the calc).
https://en.wikipedia.org/wiki/Division_by_zero
Hope that helps.
Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
