Analytics Software

I have two rows on my planning form with row suppression enabled. One is a data row the other is a formula row that simply sums the values from the data row. Works fine except in cases that result in the data row being suppressed. In that case the formula row still appears but with #error as the formula result. Is there any way to suppress the formula row or apply some logic that would overwrite the #error with a value like 0?

I've already tried IfThen to check for #error and replace but it doesn't work. Also tried creating two formula rows where the first counts the rows and the second applies the logic to overwrite #error depending on the row count.

Thanks