Registered User Joined: 9/13/2014 Posts: 11
|
Hi Bruce,
is there a possibility for following query:
price between 10 and 19.99: ABS(XAVGC9 / XAVGC20 - 1) <= .001
OR
price between 20 and 29.99: ABS(XAVGC9 / XAVGC20 - 1) <= .0009
OR
price between 30 and 40: ABS(XAVGC9 / XAVGC20 - 1) <= .0006
thanks for your ideas
Rainer
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You almost have it written already.
(10 <= C AND C < 20 AND ABS(XAVGC9 / XAVGC20 - 1) <= .001) OR (20 <= C AND C < 30 AND ABS(XAVGC9 / XAVGC20 - 1) <= .0009) OR (30 <= C AND C <= 40 AND ABS(XAVGC9 / XAVGC20 - 1) <= .0006)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|