AnsweredAssumed Answered

Moving Average calculation

Question asked by jwong on Jul 18, 2009
Latest reply on Jul 20, 2009 by comment_1


Moving Average calculation


I have a table with 2 fields: date and price. I would like to add "moving average" field for the price based on previous 5 days value.  


I have tried self-join of the table, create a calculation field, but do not know how to define the query to locate previous 5 days price based on the date of each record.


Any pointers on how to accomplish this using FM 8 will be appreciated.