Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

datanibbler
Esteemed Contributor

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

Community Browser