topic AVERAGE IF in QlikView

topic AVERAGE IF in QlikView https://community.qlik.com/t5/QlikView/AVERAGE-IF/m-p/114162#M17659 <HTML><HEAD></HEAD><BODY><P>HI ALL</P><P></P><P><SPAN style="font-size: 13.3333px;">I want to average Efficiency <> 0 but scrip error</SPAN><IMG alt="จับภาพ.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217741_จับภาพ.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 07 Nov 2018 09:30:55 GMT penpayom 2018-11-07T09:30:55Z AVERAGE IF https://community.qlik.com/t5/QlikView/AVERAGE-IF/m-p/114162#M17659 <HTML><HEAD></HEAD><BODY><P>HI ALL</P><P></P><P><SPAN style="font-size: 13.3333px;">I want to average Efficiency <> 0 but scrip error</SPAN><IMG alt="จับภาพ.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217741_จับภาพ.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 07 Nov 2018 09:30:55 GMT https://community.qlik.com/t5/QlikView/AVERAGE-IF/m-p/114162#M17659 penpayom 2018-11-07T09:30:55Z Re: AVERAGE IF https://community.qlik.com/t5/QlikView/AVERAGE-IF/m-p/114163#M17660 <HTML><HEAD></HEAD><BODY><P>use EFFICIANCY-={0}</P><P>will still Show red underlined, but works (means exclude 0)</P></BODY></HTML> Wed, 07 Nov 2018 09:41:17 GMT https://community.qlik.com/t5/QlikView/AVERAGE-IF/m-p/114163#M17660 Anonymous 2018-11-07T09:41:17Z