https://community.qlik.com/t5/QlikView/Avg-Sum-or-RangeAvg/m-p/1721240#M723589 <P>Hi,</P><P>I have the below data:</P><P>Desk&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Month 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Month 2&nbsp; &nbsp; &nbsp; &nbsp; Month 3&nbsp; &nbsp; &nbsp; &nbsp; Month 4</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 225&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;275&nbsp;</P><P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp;</P><P>How do I calculate the average across each desk for the four month period?&nbsp; Also how would I calculate it if I wanted to only use month 2, 3 and 4 for the average?</P><P>Thanks,</P><P>Daniel</P> Wed, 25 Nov 2020 16:16:04 GMT danielnevitt 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Avg-Sum-or-RangeAvg/m-p/1721240#M723589 <P>Hi,</P><P>I have the below data:</P><P>Desk&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Month 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Month 2&nbsp; &nbsp; &nbsp; &nbsp; Month 3&nbsp; &nbsp; &nbsp; &nbsp; Month 4</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 225&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;275&nbsp;</P><P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp;</P><P>How do I calculate the average across each desk for the four month period?&nbsp; Also how would I calculate it if I wanted to only use month 2, 3 and 4 for the average?</P><P>Thanks,</P><P>Daniel</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Avg-Sum-or-RangeAvg/m-p/1721240#M723589 danielnevitt 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Avg-Sum-or-RangeAvg/m-p/1721252#M723590 <P>If I understood correctly</P><LI-CODE lang="markup">RangeAvg(Month1,Month2,...) as _RangAvg,</LI-CODE> Tue, 23 Jun 2020 11:33:20 GMT https://community.qlik.com/t5/QlikView/Avg-Sum-or-RangeAvg/m-p/1721252#M723590 Taoufiq_Zarra 2020-06-23T11:33:20Z