MySQL Forums
Forum List  »  Newbie

Moving average
Posted by: angel rivero
Date: October 29, 2013 08:56AM

Moving average

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

I attach the file xlsx in the

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

Options: ReplyQuote

Written By
Moving average
October 29, 2013 08:56AM
October 29, 2013 11:51AM
October 30, 2013 02:40AM
October 30, 2013 10:06AM
October 30, 2013 10:24AM
October 30, 2013 01:10PM
November 02, 2013 04:15PM
November 03, 2013 04:18AM
November 03, 2013 10:36PM
November 04, 2013 04:53AM
November 04, 2013 10:52PM
November 05, 2013 02:30AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.