I have a report that shows members details, I want to add a KPI measure (%) showing members with null values in various feilds. Say if there is 10 members and 5 have no address details so 50% are complete. Can I do this as the report formats? If so whats the best way? How would I "count" the null values and values to create the calculation?

Cheers

In the report footer, you can add various controls with calculations.

=Sum(IsNull(SomeField), 1, 0)/Count(*)

The above expression "counts" the null values of some field and divides that number by the count of detail records in the report.

Pat, got the error 'the expression you entered has a function containing the wrong number of arguments"

I tried to use: =Sum(IsNull([address2]), 1, 0)/Count(*)
in the group footer

I have attached a sample of the report. Cheers

Sorry, I left out part of the expression. Try this:

=Sum(IIf(IsNull(SomeField), 1, 0)) / Count(*)