Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Running Average Script

eqitec
in Script Workspace and Script Triggers

Featured Replies

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.

In version 6?

  • Author

No....in Version 11Advanced

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.

  • Author

Thanks. Sorry about the version confusion.

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

Create an account or sign in to comment

https://fmforums.com/topic/73326-running-average-script/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.