SitePoint Sponsor

User Tag List

Results 1 to 24 of 24

Thread: Moving average

Threaded View

  1. #1
    SitePoint Evangelist Miguel61's Avatar
    Join Date
    Mar 2008
    Posts
    408
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Moving average

    Moving average

    Hello guys, I've problem with MySQL and need your help.

    I attach the file xlsx in the test.zip.

    This file xlsx is able to calculate the moving average (column G - AVERAGE_12_MONTHS) of the column F (F_SUM).

    The average is dynamic because in the column G is a line feed, e.g.:

    In the cell G13 I've the average of cell F2:F13, in the cell G14 the average is of cells F3:F14, in the cell G15 the average is of cells F4:F15... etc

    I need realize the same average in mysql, any suggestion?
    Can you help me?
    Any help would be very appreciated
    Attached Files Attached Files


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •