Totals in Report do not show for some records

[gmurrie99]

I have a report that calculates a total for all jobs by job. When a value is null (or maybe even negative??) the total fails to show a value. When all the numbers in the total are available, the number is calculated correctly.

I have checked the values that would go into that total, and a valid number is calculated in the subreports.

 

[patyavila]

I know this could be annoying! Go to:

[highlight]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acfctNZ_HV05186465.asp

[/highlight]

You'll find the answer to your problem... of course you'll have to include this function whenever you make numeric calculations!

(-:

Good luck! Patricia

 

[gmurrie99]

Thanks for the help, I was on a similiar track using IIf.

Like this:

=IIf(IsNull([Sum Of matcost]),0,[Sum Of matcost]))

Which I then changed to:

=NZ([Sum Of matcost],0)

While testing this functionality, I noticed a troubling thing:

Neither returns the same value as the total already calculated!

In other words, if =[Sum Of matcost]*1.15 returns $600.00

=NZ([Sum Of matcost],0) returns $563.79

What is the deal?????

 

[gmurrie99]

Never mind, I'm an idiot. Forgot to add the markup,

=NZ([Sum Of matcost]*1.15),0)


Thanks for your help!!!