https://community.qlik.com/t5/App-Development/Average-calculation-with-quot-Zero-quot-valued-months/m-p/2079565#M88564 <P>the answer will depend on more detail that you can give.&nbsp; assumptions can be made, since you wanted the average with 0 sales - this means there has to be a row for the month where sales=0.&nbsp;&nbsp;</P> <P>if you specify an expression avg(x), 0 values will be included automatically - Average 1; if you dont want the 0 values included add set analysis to exclude them avg({&lt;x={"&lt;&gt;0"}&gt;}x) here is a sample:<BR /><BR /></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="edwin_0-1685735824493.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/109030i5B9D88B5778E1E7F/image-size/medium?v=v2&amp;px=400" role="button" title="edwin_0-1685735824493.png" alt="edwin_0-1685735824493.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 02 Jun 2023 19:57:17 GMT edwin 2023-06-02T19:57:17Z https://community.qlik.com/t5/App-Development/Average-calculation-with-quot-Zero-quot-valued-months/m-p/2077651#M88396 <P>Dear Friends,</P> <P>I have a table about product sales. (StockCode, SalesDate, SalesAmount)</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Sales" style="width: 427px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/108602iB3631364AA87CE72/image-size/large?v=v2&amp;px=999" role="button" title="sales.PNG" alt="Sales" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Sales</span></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>And I want to get this table :</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Average Chart" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/108601iE9A98ED0F965FD80/image-size/large?v=v2&amp;px=999" role="button" title="average.PNG" alt="Average Chart" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Average Chart</span></span></P> <P>&nbsp;</P> <P>Average-1 : Divided By Count(MonthName)</P> <P>Average-2 : Divided By Count(<STRONG>Has Value</STRONG> MonthName)</P> <P>Could you help me please..</P> <P>Regards</P> <P>&nbsp;</P> Tue, 30 May 2023 09:16:36 GMT https://community.qlik.com/t5/App-Development/Average-calculation-with-quot-Zero-quot-valued-months/m-p/2077651#M88396 JulesVerne 2023-05-30T09:16:36Z https://community.qlik.com/t5/App-Development/Average-calculation-with-quot-Zero-quot-valued-months/m-p/2079565#M88564 <P>the answer will depend on more detail that you can give.&nbsp; assumptions can be made, since you wanted the average with 0 sales - this means there has to be a row for the month where sales=0.&nbsp;&nbsp;</P> <P>if you specify an expression avg(x), 0 values will be included automatically - Average 1; if you dont want the 0 values included add set analysis to exclude them avg({&lt;x={"&lt;&gt;0"}&gt;}x) here is a sample:<BR /><BR /></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="edwin_0-1685735824493.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/109030i5B9D88B5778E1E7F/image-size/medium?v=v2&amp;px=400" role="button" title="edwin_0-1685735824493.png" alt="edwin_0-1685735824493.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 02 Jun 2023 19:57:17 GMT https://community.qlik.com/t5/App-Development/Average-calculation-with-quot-Zero-quot-valued-months/m-p/2079565#M88564 edwin 2023-06-02T19:57:17Z