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.
Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
