Calculations with mutiple fields

[TKinzer]

I need to try to make the following logic work in a report:
IF([CashAmt] >0 and [MiscTotal] and [ReTotal] and [DiTotal] and [GasTotal] = 0 then [CshOnTranFee]else [FuFee])

To sumarize, I have want to display one fee if any of the total fields have a value in them and I want to display another fee if the CashAmt is greater then 0 and all total fields = 0.

Any suggestions?

 

[Neal]

I haven't tried it, but this might work:

Iif([CashAmt] > 0 and [MiscTotal]+[ReTotal]+[DiTotal]+[GasTotal]= 0,[CshOnTranFee],[FuFuel])