Registered User Joined: 9/11/2012 Posts: 92
|
Bruce,
I thought it would be easy but it seems I need you help again.
D1=DSS21,3
D2=DSS42,3
D1<18
or
D2<18
I tried this
(
100 *
XAVG(
(XAVG(STOC21,3) -
MIN(XAVG(STOC21, 3), 21)) / (MAX(XAVG(STOC21,3), 21)
- MIN(XAVG(STOC21, 3), 21)), 3)
<18)
or
)
(
100 *
XAVG(
(XAVG(STOC42,3) -
MIN(XAVG(STOC42, 3), 42)) / (MAX(XAVG(STOC42,3), 42)
- MIN(XAVG(STOC42, 3), 42)), 3)
<18)
But I get a formula error.
Can you help please?
thankx,
Franz J.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following condition formula.
100 * XAVG((XAVG(STOC21,3) - MIN(XAVG(STOC21, 3), 21)) / (MAX(XAVG(STOC21,3), 21) - MIN(XAVG(STOC21, 3), 21)), 3) < 18 OR 100 * XAVG((XAVG(STOC42,3) - MIN(XAVG(STOC42, 3), 42)) / (MAX(XAVG(STOC42,3), 42) - MIN(XAVG(STOC42, 3), 42)), 3) < 18
-Bruce Personal Criteria Formulas TC2000 Support Articles
|