Registered User Joined: 5/11/2012 Posts: 16
|
Hi
Trying to use the below for a RS PCF but it errors, I cant work out what the error is, any ideas?
(((C-C63)/C63)*.4)+(((C-C126)/C126)*.2)+(((C-C189)/C189)*.2)+(((C-C252)/C252)*.2))*100
Cheers
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The only thing I see off the bat is a missing parenthesis at the beginning.
((((C-C63)/C63)*.4)+(((C-C126)/C126)*.2)+(((C-C189)/C189)*.2)+(((C-C252)/C252)*.2))*100
Or maybe:
40 * C / C63 + 20 * C / C126 + 20 * C / C189 + 20 * C / C252 - 100
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 5/11/2012 Posts: 16
|
Thanks Bruce !
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|