Percentage formula does not work if denominator is zero
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!
Answers

Post your formula so we can see what you have and help you figure out the issue.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

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)

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

@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.

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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

@APete It would look like this:
=IFERROR([May FY23]2 / [May FY23]3 * 100, 0)

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)

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

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)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!