How do I get a variable to persist in an exploration? My explore:
ColumnVal = {formula here}
AddColumn(ColumnVal, "Value");
I'd like to add another column ("ColRank") that gives a value of 1,2
or 3 if ColumnVal is in the top third, middle third, or bottom third
of the whole set of ColumnVal results - eg:
ColumnVal ranges from 1 to 100 for all stocks in this exploration
If ColumnVal = 25, ColRank = 3
If ColumnVal = 75, ColRank = 1
etc...
Many thanks,
Alex
