topic Formula help needed - why does &quot;avg.&quot; do so? in QlikView https://community.qlik.com/t5/QlikView/Formula-help-needed-why-does-quot-avg-quot-do-so/m-p/540014#M483395 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a very stupid question:</P><P>- I have the following code:</P><P>&nbsp; &gt;&gt;&nbsp; = avg({$&lt;%Datum = {'$(v_last_workday_Date)'}&gt;} ((BpF_FS+BpF_SS)/2))&nbsp; &lt;&lt;</P><P>- What this is supposed to do is clear - %Datum is any day, v_last_workday is (yesterday or, if it's a Monday, Friday) and I have two values, BpF_FS and&nbsp; BpF_SS.</P><P>- This is the final version (after approx. 30min) and it works - but if I understand the avg fct correctly, I should not be needing that "/ 2"? There are only two values on that specific day, so the avg should automatically be (the sum, divided by two)?</P><P>I just don't understand this. Can somebody please explain that to me?</P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Thu, 04 Jul 2013 09:47:51 GMT datanibbler 2013-07-04T09:47:51Z Formula help needed - why does "avg." do so? https://community.qlik.com/t5/QlikView/Formula-help-needed-why-does-quot-avg-quot-do-so/m-p/540014#M483395 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a very stupid question:</P><P>- I have the following code:</P><P>&nbsp; &gt;&gt;&nbsp; = avg({$&lt;%Datum = {'$(v_last_workday_Date)'}&gt;} ((BpF_FS+BpF_SS)/2))&nbsp; &lt;&lt;</P><P>- What this is supposed to do is clear - %Datum is any day, v_last_workday is (yesterday or, if it's a Monday, Friday) and I have two values, BpF_FS and&nbsp; BpF_SS.</P><P>- This is the final version (after approx. 30min) and it works - but if I understand the avg fct correctly, I should not be needing that "/ 2"? There are only two values on that specific day, so the avg should automatically be (the sum, divided by two)?</P><P>I just don't understand this. Can somebody please explain that to me?</P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Thu, 04 Jul 2013 09:47:51 GMT https://community.qlik.com/t5/QlikView/Formula-help-needed-why-does-quot-avg-quot-do-so/m-p/540014#M483395 datanibbler 2013-07-04T09:47:51Z