https://community.qlik.com/t5/QlikView/Average-not-working/m-p/1512524#M602025 <P>What is the expression you are using in the Pivot table?</P><P>&nbsp;</P><P>-Rob</P> Mon, 26 Nov 2018 21:01:25 GMT rwunderlich 2018-11-26T21:01:25Z https://community.qlik.com/t5/QlikView/Average-not-working/m-p/1512407#M602024 <P>Dear All,</P><P>Average not working in expression level.</P><P>in MONTH column first 3 months and Battery issue % is coming from load line and coming to Nov'18 % is on script based.</P><P>ideally when i put average in expression it has to come..but it's not working .</P><P>right calculation of Average&nbsp; is&nbsp; 10.51% but in expression is taking only load line that is 12.8%</P><P>can any one help on this...thanks in advance</P><P>script attached for reference.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 900px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/998iE636779967E67504/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Mon, 26 Nov 2018 16:28:02 GMT https://community.qlik.com/t5/QlikView/Average-not-working/m-p/1512407#M602024 bhaskar_anumand 2018-11-26T16:28:02Z https://community.qlik.com/t5/QlikView/Average-not-working/m-p/1512524#M602025 <P>What is the expression you are using in the Pivot table?</P><P>&nbsp;</P><P>-Rob</P> Mon, 26 Nov 2018 21:01:25 GMT https://community.qlik.com/t5/QlikView/Average-not-working/m-p/1512524#M602025 rwunderlich 2018-11-26T21:01:25Z