SumIIF with variables

[jamphan]

I have the following formula in a report that calculates the current balance if the Type Loss is 4. I also need this field to calculate totla loss if the type loss is 4U, 4F, or "". Is there anyway I can add these other variables in to get a grand total in this one field? Thanks!

=Sum(IIf([numType Loss]="4",[curCurrent Balance],0))

 

[jamphan]

Thanks. When I put "" I meant a null value.