Report Fails with Null Values

[diofree]

I have a report that aggregates information on an individual from a table.

Basically the report has three columns, each is averaging information.

Column1
*If assessment type field = "Lead", average score field values

Column2
*If assessment type field = "Self", average score field values

Column3
*If assessment type field = "Other", average score field values

This report works great as long as there is at least one record labelled for each of the three types above. If there are no records with eg. "Self" in the type field, the report throws and error and won't run. I'd prefer it just give me the report anyway but with blank values for that column if there are none. Can I do this?

thanks

 

[Alc]

Without seeing the formulae you're using I can't be sure, but perhaps using the Nz() function for the problem fields might help?