Hi there,

I was wondering why the average on the report wizard calculates empty fields as value 0 entries and therefore distorts the result?
Example: report lead with converted information
this report will contain all leads but only some of them will be converted or rejected
only for rejected and converted leads there will be information about the 'days to qualify/reject'
it would be interesting to get the average of these values but the average is being calculated based on all leads in this report.

Is it possible to exclude empty fields from the average calculation?

Thanks for any advice.

Robert