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.
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
