1 Reply Latest reply on Dec 5, 2013 10:46 AM by 8f322970-c623-499b-969c-796b8027fd39

    Rolling Average Forecast for 6 and 12 months

    User197665

      Hi,

       

      I am completely new to OBIEE and have never used it before and I am having trouble creating a rolling average formula that will calculate the forecast for the next 6 and next 12 months. For example,

       

      JanFebMarAprMayJunJulAugSep
      35156416354761738869958104051345254321514513
      41635476173886995810405133713943253234432
      Rolling avg fcst4999344828109914
      Jan-JunFeb-JulMar-Aug

       

      I have tried the MAVG function, but that only calculates the Previous avg of the available months.

       

      I have created a repository variable in the RPD with CURRENT_MONTH, but when I try to add the VALUEOF(CURRENT_MONTH)+6 - it gives an error.

       

      Any input is totally appreciated!