I'm trying to run a Col Rank formula on a "BLOCKERASECYCLE" column and then output the result to a new column "TEMPCOLUMN"
However it runs Col Rank even on rows that I hide and exclude (rows are not "VERSION1").
How can I get Col Rank to skip rows that I hide and exclude (non "VERSION1" rows)?
BLOCKERASECYCLE_COL = Column("BLOCKERASECYCLE");
foundrows = dt << Get Rows Where(:PART_VERSION=="VERSION1");
dt<<Select Rows(foundrows);
dt<<Invert Row Selection;
dt<<Exclude;//Exclude non-VERSION1 rows
dt<<Hide;//Hide non-VERSION1 rows
dt<<Invert Row Selection;
dt<<New Column("TEMPCOLUMN", Numeric, Formula(Col Rank(BLOCKERASECYCLE_COL)));