A sum of two expressions but Nulls causing problems

  • Thread starter Thread starter amb
  • Start date Start date
A

amb

I have a straight calculation that does the following

=Sum([Expr11]+[Expr12])

Sadly Expr11 and Expr12 can sometimes be NULL.

If either are null I want the calculation to simply return 0. At the
moment if I run the report I get #Error, and if I run the report as a
subreport as part of the overall the subreport simply doesnt print at all.


Any ideas?

Amb
 
Hi.
You will want to use the Nz() function, this will substitute a zero for the
blank.
Hope this helps.
Fons
 
Also, you could try
SUM(Expr11) + SUM(Expr12)


Fons said:
Hi.
You will want to use the Nz() function, this will substitute a zero for the
blank.
Hope this helps.
Fons

amb said:
I have a straight calculation that does the following

=Sum([Expr11]+[Expr12])

Sadly Expr11 and Expr12 can sometimes be NULL.

If either are null I want the calculation to simply return 0. At the
moment if I run the report I get #Error, and if I run the report as a
subreport as part of the overall the subreport simply doesnt print at all.


Any ideas?

Amb
Click to expand...
Click to expand...
 
Back
Top