5 Replies Latest reply: Nov 20, 2012 6:24 AM by Muhammad Irfan RSS

    Monthly Avg balance

    Muhammad Irfan

      I have daily balances in my table as following

       

       

      Key Date
      Balance
      109/01/201210
      109/02/201210
      109/03/201210
      109/04/201220
      109/05/201220
      109/06/201220
      109/07/201220
      109/08/201220
      109/09/201215
      109/10/201215

       

      now the thing is i wana calculate avg weekly monthly and quarterly balance the formula i am using is sum(AGGr(avg(Balance),Week) and when i use the same for the month it shows the same value as in sum(AGGR(AVG(Balance),CalenderMonth) so please guys let me know where i am going wrong.