Registered User
Joined: 10/7/2004
Posts: 1,178
|
I'm testing some interesting Easy Scans, and would like three separate formulas:
The first would indicates there have been none of these: C<=BBbot(2.0,21) selecting "in the last 63 days".
The second would indicate there have been none of these: C>=BBtop(2.0,21) again selecting "in the last 63 days".
The third would indicate there have been none of either of the above (both) again selecting "in the last 63 days".
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following for the first.
TrueInRow(C > BBBOT(2, 21), 63) = 63
The following for the second.
TrueInRow(C < BBTOP(2, 21), 63) = 63
And the following for the third.
TrueInRow(ABS(C - AVGC21) < 2 * STDDEV21, 63) = 63
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 10/7/2004
Posts: 1,178
|
Yes, each works. Thanks!
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|