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.
|
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
|