3 Replies Latest reply: May 14, 2009 5:12 PM by hsbc_thom RSS

    Average of values in the Month to Date

      Hi all. I have some numeric data which is recorded on a daily basis. My users have the option to choose a particular day from a listbox, and I want to show them the actuals for the selected day, plus the average value for the selected month.

      I'm really struggling to get the average for the month to date though. I'm pretty sure it needs some set analysis, but I just can't get it to work.

      I have attached a qvw with an example and a further description of the problem, and I will also attach the example data for reference.

      Any help would be appreciated!

      Thanks
      Thom.