 Platinum Customer
Joined: 6/30/2014
Posts: 60
|
The following code should give me a column of values from 3,2,1,0. "0" is for no gap / "1" is for an opening gap today / "2" is for an opening gap yesterday and / "3" is for an opening gap two days ago. I am not getting the today value of 1. Any ideas?
IIF(O>=C.1+ATR.1 AND C>O AND ATR.1>0,1,IIF(O.1>=C.2+ATR.2 AND C.1>O.1 AND ATR.2>0,2,IIF(O.2>=C.3+ATR.3 AND C.2>O.2 AND ATR.3>0,3,0)))
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Maybe the following?
IIF(O >= C1 + ATR1.1 AND C > O AND ATR1.1 > 0, 1, IIF(O1 >= C2 + ATR1.2 AND C1 > O1 AND ATR1.2 > 0, 2, IIF(O2 >= C3 + ATR1.3 AND C2> O2 AND ATR1.3 > 0, 3, 0)))
Or the following?
SinceTrue(O >= C1 + ATR1.1 AND C > O AND ATR1.1 > 0, 3) + 1
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Platinum Customer
Joined: 6/30/2014
Posts: 60
|
Thanks, Bruce. I am using the first example and it is working fine.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|