Formula causing Error due to "-" is there a way around

[Huddle]

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

[Micron]

Not sure if your error is the result of [Bat_Pct] when SumOfSumOfBat is null or if it's because of the "-". Is this a text field? If not, you can't use -
try
IIf(Nz([SumOfSumOfBat_Totals],0)=0,"-",[Bat_Pct])*1
or
IIf(Nz([SumOfSumOfBat_Totals],0)=0,0,[Bat_Pct])*1

[CJ_London]

What are you actually trying to achieve? It looks like you want to display a - instead of 0. If that is the case then just use the format property

[ArviLaanemets]

Is SumOfSumOfBat_Totals a text field? I assume, it is numeric one. And the result of calculation when source is numeric must be numeric or Null also. Especially when you want to insert the result into some numeric field or control too. Differently of Excel, Field types in Access have much more to say, what you can enter or not.

[Huddle]

OK, Thank you for all your help.