topic Re: Excluding zeros from Averages in a table in QlikView https://community.qlik.com/t5/QlikView/Excluding-zeros-from-Averages-in-a-table/m-p/396308#M559829 <HTML><HEAD></HEAD><BODY><P>You could try</P><P></P><P>Avg({&lt;Value-={0}&gt;}Value)</P><P></P><P>or</P><P></P><P>Avg(if(Value&gt;0,Value))</P></BODY></HTML> Wed, 24 Apr 2013 17:18:12 GMT danielrozental 2013-04-24T17:18:12Z Excluding zeros from Averages in a table https://community.qlik.com/t5/QlikView/Excluding-zeros-from-Averages-in-a-table/m-p/396307#M559828 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I was wondering if it was possible to exclude zeros when trying to get the average of a column in a table . Currently the average is including the Zeros ($) making the figure innacurate. Please help. </P><P></P><P>Thanks,</P><P></P><P>Kevin</P></BODY></HTML> Wed, 24 Apr 2013 14:36:48 GMT https://community.qlik.com/t5/QlikView/Excluding-zeros-from-Averages-in-a-table/m-p/396307#M559828 2013-04-24T14:36:48Z Re: Excluding zeros from Averages in a table https://community.qlik.com/t5/QlikView/Excluding-zeros-from-Averages-in-a-table/m-p/396308#M559829 <HTML><HEAD></HEAD><BODY><P>You could try</P><P></P><P>Avg({&lt;Value-={0}&gt;}Value)</P><P></P><P>or</P><P></P><P>Avg(if(Value&gt;0,Value))</P></BODY></HTML> Wed, 24 Apr 2013 17:18:12 GMT https://community.qlik.com/t5/QlikView/Excluding-zeros-from-Averages-in-a-table/m-p/396308#M559829 danielrozental 2013-04-24T17:18:12Z