Guest
Joined: 9/18/2004 Posts: 247
|
I need a PCF to calculate the % Change in Average Volume from one week to the next.
Here is how I formulated my PCF. Is this correct ? It seems to work. 100*(((avgV5)/(avgV5.5))-1
Do you have better ideas / suggestions on how to formulate this PCF ? Much appreciate
if you can use your expertise to help me.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I'm not sure about the parentheses, but otherwise the form should work:
100 * (AVGV5 / AVGV5.5 - 1)
You may wish to review the following:
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
|