topic Re: Avg Revenue Logic in QlikView https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122672#M900453 <HTML><HEAD></HEAD><BODY><P>Hi Marcus,</P><P>Avg fuction gives 3012</P><P>but user answer is 3508.</P></BODY></HTML> Fri, 22 Jul 2016 05:23:17 GMT ajsjoshua 2016-07-22T05:23:17Z Avg Revenue Logic https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122666#M900445 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I want to calculate the Doctor wise Avg Revenue</P><P>the avg revenue of these two doctor is <SPAN style="font-size: 13.3333px;">3,508 but i am not sure of the formula</SPAN></P><P><SPAN style="font-size: 13.3333px;">what will be the logic behind this</SPAN></P><P></P><P>4,242&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DR. ABDUL GHANI</P><P>1,782&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DR. SACHIN</P><P>3,508</P><P></P><P></P><P></P><P>Regards,</P><P>Joshua.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122666#M900445 ajsjoshua 2020-11-25T16:16:04Z Re: Avg Revenue Logic https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122667#M900446 <HTML><HEAD></HEAD><BODY><P>Have you tried <STRONG>avg()</STRONG> ?</P></BODY></HTML> Fri, 22 Jul 2016 05:13:29 GMT https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122667#M900446 tresB 2016-07-22T05:13:29Z Re: Avg Revenue Logic https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122668#M900447 <HTML><HEAD></HEAD><BODY><P>Hi tresesco,</P><P>I am yet to try it in qlikview</P><P>I got stuck while analysing the excel data itself.</P></BODY></HTML> Fri, 22 Jul 2016 05:14:52 GMT https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122668#M900447 ajsjoshua 2016-07-22T05:14:52Z Re: Avg Revenue Logic https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122669#M900448 <HTML><HEAD></HEAD><BODY><P>Maybe this is helpful: <A href="https://community.qlik.com/qlik-blogpost/3208">Average – Which average?</A></P><P></P><P>- Marcus</P></BODY></HTML> Fri, 22 Jul 2016 05:16:21 GMT https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122669#M900448 marcus_sommer 2016-07-22T05:16:21Z Re: Avg Revenue Logic https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122670#M900449 <HTML><HEAD></HEAD><BODY><P>In excel there is AVERAGE()</P></BODY></HTML> Fri, 22 Jul 2016 05:16:53 GMT https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122670#M900449 tresB 2016-07-22T05:16:53Z Re: Avg Revenue Logic https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122671#M900451 <HTML><HEAD></HEAD><BODY><P>Hi tresesco,</P><P>Average function gives me 3012</P><P>but user answer is <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">3,508</SPAN></P><P></P></BODY></HTML> Fri, 22 Jul 2016 05:22:13 GMT https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122671#M900451 ajsjoshua 2016-07-22T05:22:13Z Re: Avg Revenue Logic https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122672#M900453 <HTML><HEAD></HEAD><BODY><P>Hi Marcus,</P><P>Avg fuction gives 3012</P><P>but user answer is 3508.</P></BODY></HTML> Fri, 22 Jul 2016 05:23:17 GMT https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122672#M900453 ajsjoshua 2016-07-22T05:23:17Z Re: Avg Revenue Logic https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122673#M900455 <HTML><HEAD></HEAD><BODY><P>Per pure maths is 3012 correct by only two records of 4242 and 1782. Therefore I assume that there more records are included or that there is some weighting. Please share more details to them.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 22 Jul 2016 05:35:34 GMT https://community.qlik.com/t5/QlikView/Avg-Revenue-Logic/m-p/1122673#M900455 marcus_sommer 2016-07-22T05:35:34Z