Zeros or null in average

[chris2001dc]

Hi,

I'am working with Cognos 8.3 and I'am trying to get the average, but I need to include the zero or null values in this calculation, how should I do it?

Thank you.

[blom0344]

averages should xclude nulls , but not zeroes. To take  null into account use the coalesce function within the average expression to force nulls to be treated as zeroes..