Registered User Joined: 10/7/2004 Posts: 76
|
How can I write a pcf for the Maximum 30 day moviing average over the last 30 days.
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following if the Moving Average is Simple:
MAX(AVGC30,30)
If the Moving Average is Exponential, please try the following instead:
MAX(XAVGC30,30)
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|