| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 3/8/2018
Posts: 30
|
How would i write a one line formula for multiline formula without using the build in ones
for- Price percent change today and Price history Net between
example
Price percent change today betweeen (min -0.40 and max 0.40)
Price history Net change between (min -0.20 and max 0.20)
Thanks
Dipan
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
ABS((C-C1)/C1) * 100 < .4 AND ABS(C-C1) <= .2
|
|
Gold Customer
Joined: 3/8/2018
Posts: 30
|
When i use the following formula, i see a unique issue
The editior shows Formula Error .. View Details shows
Error in Formula - Expected ( At Position 33.
- if i run my scan , it does work , so i am confused as to why it shows the error.
Thanks
Dipan
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Could you have re-typed it with a space in ABS ( instead of writing ABS(?
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 3/8/2018
Posts: 30
|
QUOTE (Bruce_L)
Could you have re-typed it with a space in ABS ( instead of writing ABS(?
it looks good now. Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |