#Error

[teiben]

I must be brain dead today, but I can't figure this out. I have a field on a report called PotSales; in the report footer I have the following formula =Sum([PotSales]), which works if there are PotSales, if there isn't it generates #Error, how the heck do I force it to result in 0?

Help

 

[boblarson]

You need to use the NZ function:

=Sum(Nz([PotSales],0))