If I launch the sim the last month, I get few companies like FLTN, ILNX or KMDA that have no Earnings, and their ROE and so are worst than the median of their Industry, and should have not pass the filter.
I took a quick look, and the picture of the snapshot shows TTM data, and your rules are Quarterly. So this make it to pass your rules. (FLNT has positive quarterly roa, and negative in a TTM basis)
You can fix negative TTM by adding a “AND ROA%TTM > 0” to your rules or change them to a ttm base.
Not sure if this fix all the other things… I only checked for ROA.
(Sorry the bad English)
Hope this helps,
The Snapshot uses this Aggregate() for the industry, not a median. Aggregate has some key defaults too, like 16.5% outlier trim from both sides
Please show a specific example of a problem so we can better assist. For example there are no column names in one of the screenshots. Also there seems to be two problems mentioned, so it’s a bit confusing.