I am using the below formula that works if the SumOfSumOfBat_Totals has data, but if it doesn't and puts a dash it causes and error because it is a percentage. The formula works in other areas where it is not a percentage.
Is there a way to clear the Error with IFERROR or NZ?
IIf([SumOfSumOfBat_Totals]=0,"-",[Bat_Pct])*1