Percentage formula does not work if denominator is zero

APete

Hi, I have the formula for percentage but when denominator is zero, instead of showing 0%, it does not show anything. How can I make it such that it returns zero if that is appropriate so that my run chart does not look like its missing data points? Thank you!

Kleerfyre

Post your formula so we can see what you have and help you figure out the issue.

Paul Newcome

It sounds like you have an IFERROR built in. If so, try adjusting the output of that to zero instead of blank.

=IFERROR(percentage_formula, "")

adjusted to

=IFERROR(percentage_formula, 0)

APete

Here is the formula =[May FY23]2 / [May FY23]3 * 100

APete

@Paul Newcome thank you for your response, I see that you shared a formula which is =IFERROR(percentage_formula, 0). My current formula is =[May FY23]2 / [May FY23]3 * 100. How should I write the formula, with your input? Thanks so much.

Andrée Starå

Hi @APete

I hope you're well and safe!

Try something like this.

=IFERROR([May FY23]2 / [May FY23]3 * 100, 0)

Did that work?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@APete It would look like this:

=IFERROR([May FY23]2 / [May FY23]3 * 100, 0)

Harley Esguerra

hello! I want to piggy back on @APete 's question but using my formula? @Paul Newcome how would you fix this formula as I also would like this to result to 0% when I have a ZERO denominator. Thanks in advance!

=([Helper%Complete]@row / Duration@row)

Paul Newcome

@Harley Esguerra You would use the IFERROR exactly as I suggested in my last comment.

Harley Esguerra

Thanks @Paul Newcome that worked but one final question. I applied the same formula to the below question but I am getting a blank cell when the denomonitor is 0%. The cell that I put this formula into btw is "date" formatted. What would the workaround be for this?

=IFERROR([eStart Date]@row + (Duration@row / [HelperCPI%]@row), 0)