AnsweredAssumed Answered

Moving Average calculation

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

Title

Moving Average calculation

Post

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. 

 

 

Outcomes