Running Average Script

[eqitec]

Can anyone suggest an approach to calculating a 15 record average starting with the 15th record. E.g., the 16th record would calculate a new average by dropping record #1 and adding record #16. The 17th record would drop record #2 and include record #17....and so on.

Thanks.

[comment]

In version 6?

[eqitec]

No....in Version 11Advanced

[comment]

If you want the moving average to be based on the current found set and sort order, use the GetNthRecord() function to retrieve the preceding values. In the Advanced version, you could use a custom function for this instead of spelling out 14 calls to the GetNthRecord() function - but the difference is largely cosmetic.

---

P.S. Please update your profile - or use the option to indicate version when opening a new thread.

[eqitec]

Thanks. Sorry about the version confusion.

[Lee Smith]

Please update your profile so this doesn't continue to happen.

To update it, go to the Menu, Select "MY PROFILE" >> "Control Panel" >> FileMaker Questions (first group, last entry)

Lee