0 Replies Latest reply: Jul 4, 2013 5:47 AM by Friedrich Hofmann RSS

    Formula help needed - why does "avg." do so?

    Friedrich Hofmann

      Hi,

       

      I have a very stupid question:

      - I have the following code:

        >>  = avg({$<%Datum = {'$(v_last_workday_Date)'}>} ((BpF_FS+BpF_SS)/2))  <<

      - 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  BpF_SS.

      - 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)?

      I just don't understand this. Can somebody please explain that to me?

      Thanks a lot!

      Best regards,

       

      DataNibbler