Registered User Joined: 11/19/2015 Posts: 459
|
Hello.
How would I construct a formula for:
Monthly Change * (2 x Weekly Change)?
Thank you.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You can't mix time frames, but you could maybe do something like the following in a daily time frame.
2 * (C - C5) * (C - C21)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 11/19/2015 Posts: 459
|
Thanks, Bruce. I knew it came down to using bar counts but I wasn't certain of how to put it together.
Thank you very much for the help. Works just as needed.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|