If not null, sum a field? 2

[DownEaster]

In a report, I need to sum the contents of a field [$AMT] if another field

= is not null.  I have tried the following expression in the control source of the field I want to sum, but am getting a message "This control has a reference to itself"
=Sum(IIf(IsNull([Code]),0,[$ AMT]))
Any suggestions would be appreciated!

 

[lupins46]

If this formula is going to work surely it should be in control that should hold the total.

 

[KenReay]

How about

=Sum(Nz(

,0,[$ AMT])), in the total control


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - [URL unfurl="true"]www.kenneth.reay.btinternet.co.uk[/URL]
UK

 

[DownEaster]

Thanks - just tried the code in a new control for the total and it worked fine!