Report writer does not want to recongnize null values in computing averages.

[RickWarner]

I'm using 10.1 and avg function in Report Writer is including Null values in the computation of avg, I have the exclude null values on false. Does anyone have any idea? when I compute the Mean value using the statistics summary the answer comes out correct, and excludes the null values.

Thank you

[XanderBakker]

Why would you want to include Null values in your statistics calculation? What value do the Null values represent? Normal behavior would be to return Null if Null values are not excluded.

[RickWarner]

For some reason they are being included as if they were 0.

I dont want to include in statistical analysis.

Sent from my HTC Inspire™ 4G on AT&T

[XanderBakker]

If you have "exclude null values on false", maybe you should set this to true... (to exclude the null values)...

[RickWarner]

Thank you, I tried that, didn’t work.