I've created a calculated field in a pivot table to average the values of other fields within the pivot table. Problem is that the AVERAGE function is treating null values as zero... which skews the average.

Is there a way to prevent this?