topic Re: Report writer does not want to recongnize null values in computing averages. in New to GIS Questions https://community.esri.com/t5/new-to-gis-questions/report-writer-does-not-want-to-recongnize-null/m-p/685945#M1817 <HTML><HEAD></HEAD><BODY><P>Thank you, I tried that, didn’t work.</P></BODY></HTML> Tue, 06 Jan 2015 01:24:31 GMT RickWarner 2015-01-06T01:24:31Z Report writer does not want to recongnize null values in computing averages. https://community.esri.com/t5/new-to-gis-questions/report-writer-does-not-want-to-recongnize-null/m-p/685941#M1813 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Thank you</P></BODY></HTML> Mon, 05 Jan 2015 20:30:30 GMT https://community.esri.com/t5/new-to-gis-questions/report-writer-does-not-want-to-recongnize-null/m-p/685941#M1813 RickWarner 2015-01-05T20:30:30Z Re: Report writer does not want to recongnize null values in computing averages. https://community.esri.com/t5/new-to-gis-questions/report-writer-does-not-want-to-recongnize-null/m-p/685942#M1814 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Mon, 05 Jan 2015 22:34:31 GMT https://community.esri.com/t5/new-to-gis-questions/report-writer-does-not-want-to-recongnize-null/m-p/685942#M1814 XanderBakker 2015-01-05T22:34:31Z Re: Report writer does not want to recongnize null values in computing averages. https://community.esri.com/t5/new-to-gis-questions/report-writer-does-not-want-to-recongnize-null/m-p/685943#M1815 <HTML><HEAD></HEAD><BODY><P>For some reason they are being included as if they were 0.</P><P></P><P> I dont want to include in statistical analysis. </P><P></P><P>Sent from my HTC Inspire™ 4G on AT&amp;T</P></BODY></HTML> Mon, 05 Jan 2015 23:30:31 GMT https://community.esri.com/t5/new-to-gis-questions/report-writer-does-not-want-to-recongnize-null/m-p/685943#M1815 RickWarner 2015-01-05T23:30:31Z Re: Report writer does not want to recongnize null values in computing averages. https://community.esri.com/t5/new-to-gis-questions/report-writer-does-not-want-to-recongnize-null/m-p/685944#M1816 <HTML><HEAD></HEAD><BODY><P>If you have "<SPAN style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">exclude null values on false", maybe you should set this to true... (to exclude the null values)...</SPAN></P></BODY></HTML> Mon, 05 Jan 2015 23:33:40 GMT https://community.esri.com/t5/new-to-gis-questions/report-writer-does-not-want-to-recongnize-null/m-p/685944#M1816 XanderBakker 2015-01-05T23:33:40Z Re: Report writer does not want to recongnize null values in computing averages. https://community.esri.com/t5/new-to-gis-questions/report-writer-does-not-want-to-recongnize-null/m-p/685945#M1817 <HTML><HEAD></HEAD><BODY><P>Thank you, I tried that, didn’t work.</P></BODY></HTML> Tue, 06 Jan 2015 01:24:31 GMT https://community.esri.com/t5/new-to-gis-questions/report-writer-does-not-want-to-recongnize-null/m-p/685945#M1817 RickWarner 2015-01-06T01:24:31Z