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.