topic Re: divide by expression in QlikView https://community.qlik.com/t5/QlikView/divide-by-expression/m-p/395975#M489210 <HTML><HEAD></HEAD><BODY><P>yeh thanx was correct, </P><P></P><P>grtz Ed</P></BODY></HTML> Sat, 01 Dec 2012 10:58:46 GMT 2012-12-01T10:58:46Z divide by expression https://community.qlik.com/t5/QlikView/divide-by-expression/m-p/395973#M489208 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I want to devide some values but i cant find the correct expression</P><P>i've a tabe witch som coloms with sum expressions and a total</P><P></P><P><STRONG> sum (<A>)</A></STRONG><A>, <STRONG>sum (<B>)</B></STRONG><B> , <STRONG>sum (<C>)</C></STRONG> and <STRONG>sum (</STRONG></B></A><A>)+sum (<B>)+sum(<C>)</C></B></A></P><P></P><P>now i want to make an other expression wich gives me the divide of <A>,<B> and <C></C></B></A></P><P></P><P>sum <A>+sum <B>+sum<C><STRONG>/3</STRONG> does not give the correct answer ex a=5, b=4 and c=7 outcome shout be 16/3=5,3 but outcome qlikview =10 </C></B></A></P><P>Avg (<A>+<B>+<C>) does not work either, outcome qlikview = 16</C></B></A></P><P>Avg (sum (<A>) + sum (<B>) + sum (<C>) gives error in expression</C></B></A></P><P></P><P>below a screenshot</P><P></P><P><IMG alt="http://img585.imageshack.us/img585/2238/qlikview.jpg" class="jive-image" src="http://img585.imageshack.us/img585/2238/qlikview.jpg" /></P><P>help me </P><P></P><P></P><P>grtz Ed</P></BODY></HTML> Fri, 30 Nov 2012 20:16:11 GMT https://community.qlik.com/t5/QlikView/divide-by-expression/m-p/395973#M489208 2012-11-30T20:16:11Z Re: divide by expression https://community.qlik.com/t5/QlikView/divide-by-expression/m-p/395974#M489209 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>(sum (a)+sum (b)+sum(c))<STRONG>/3</STRONG></P><P></P><P><STRONG>Hope it helps<BR /></STRONG></P></BODY></HTML> Fri, 30 Nov 2012 20:18:44 GMT https://community.qlik.com/t5/QlikView/divide-by-expression/m-p/395974#M489209 MayilVahanan 2012-11-30T20:18:44Z Re: divide by expression https://community.qlik.com/t5/QlikView/divide-by-expression/m-p/395975#M489210 <HTML><HEAD></HEAD><BODY><P>yeh thanx was correct, </P><P></P><P>grtz Ed</P></BODY></HTML> Sat, 01 Dec 2012 10:58:46 GMT https://community.qlik.com/t5/QlikView/divide-by-expression/m-p/395975#M489210 2012-12-01T10:58:46Z