Is it possible to use this in a ranking system without modifying it, but rather leave it as “LoopAvg (” Abs (Sales (Ctr, Qtr) -Sales (Ctr + 1, Qtr)) / Sales (Ctr, TTM) "), 10.0) 0.025 "
and also lower value = Universe = Stock formula
Greater value = Composite
Or will the outcome of such a rating rule be unsuccessful?
It’s from the “Sales Focus” screen. (Eliminate excessive quarterly sales variability)
I’m afraid I don’t fully understand the question, but you CAN use a true/false rule in a ranking system: it’s a Boolean node.
I have used it like this:
You have a Boolean statement in there with a lower values ranking. The statement is either true or false. If it’s true it’ll give a value of 1 and if it’s false it’ll give a value of 0. So by giving it a lower values ranking you are privileging those stocks for which it’s false. That’s not what you want.
If you want to stick with the inequality in the formula, then use the Boolean values option. If you want to rank all stocks on how close to 0 they are on this measure, then get rid of “< 0.025” and rank on lower values.
Ok. Thank you very much, Yuval . I’ll test with various options.