Report Assistance Requested

[Maverick_777]

Hi guys,
I have an issue where to put the Nz indicator to the following calculation in an access report. Can anyone help?

=IIf(Sum([Expr1])>Sum([Expr2]),(Sum([Expr1])-Sum([Expr2])))

Thanks

This is part of an text box calculating as part of a footer.

After solving this I may need to extend this question into summing a text box later. We'll see...

Thanks for any help provided.

 

[Joe4]

I think you will probably need to use it wherever you may have a Null value. For example, if Expr1 may be Null, then every instance of:
[Expr1]
will probably need to be replaced with
Nz([Expr1],0)+0

Likewise for Expr2.