Hi - could some kind soul please help me with this:
I want to use expression A when condition N is met
Expression B otherwise.
Is eval the right way to do this? If so, how do I define it. If not please suggest alternative
Thanks!
Hi - could some kind soul please help me with this:
I want to use expression A when condition N is met
Expression B otherwise.
Is eval the right way to do this? If so, how do I define it. If not please suggest alternative
Thanks!
Yes, Eval is the right way to do this. The form would be:
Eval(N,A,B)
That’s pseudocode. This example should actually work when pasted into a blank rule:
Eval(MktCap>2000,ROI%TTM>5,ROE%TTM>10)
If the market cap of a company is greater than $2 billion then it will pass if it has an ROI greater than 5%. If it is under $2 billion then it will pass if it has an ROE greater than 10%.
EDIT: Oh, and I should mention that you can nest Eval statements to form decision trees. Those examples become much more complicated, of course.
thanks!