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
Solved! Go to Solution.
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.
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.