How to remove #Divide By when result is 0

Jonnell Sherman

This is my formula and the result is zero which is accurate, however the cell is displaying #DIVIDE BY. How can I change it to show 0% vs the error?

=([Metric 1]@row / Totals@row)

Heather_Verde

Can you put an IF statement like =IF(Totals@row = "0", "0%", ([Metric 1]@row / Totals@row)) ?

Jonnell Sherman

Thank you!!! Actually were able to figure it out, sharing in case anyone comes across this in the future and needs assistance.

=IFERROR(SUM([Metric 3]@row / Totals@row), "0%")

Thanks!