Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

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

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

0 Replies