6 Replies Latest reply: Feb 7, 2014 4:10 AM by Frank Hartmann RSS

    moving average

    Frank Hartmann

      Hallo QV Community

       

      I use the following formula in the chart for accounting the moving average:

       

      Rangesum(above(Y,0,Row())/Row()

       

       

      mAvg.png

       

      Is there any possibility to export the last value (=9) of the Rangesum formula to a textbox?

      I tried to use the Rangesum formula within a textbox but it doesnt work for specific month.

       

      The reason why i want to get this value to a textbox is because i need the value exported per macro to a powerpoint

      document as picture or  as object.

       

      any ideas?

       

      thanks for your help