Show 100%

Marilen.Navarro103391

How to show 100% if "0" is the answer on the formula below.

=IFERROR(SUM([121-365 Days]1:[>365 Days]@row) / [Grand Total]@row, 0)

Thanks.

L_123

=IFERROR(if(SUM([121-365 Days]1:[>365 Days]@row) / [Grand Total]@row = 0,1,SUM([121-365 Days]1:[>365 Days]@row) / [Grand Total]@row), 0)

Something like that?

L_123

=IFERROR(if(SUM([121-365 Days]1:[>365 Days]@row) / [Grand Total]@row = 0,1,SUM([121-365 Days]1:[>365 Days]@row) / [Grand Total]@row), 0)

Something like that?