Custom Formula Screen Factors Outputting Unnecessary Fields

Research
1

I am using nested custom formulas in Screener to produce variables used in calculation (Custom Formula inside Custom Formula). I am successfully outputting the correct values for the variables in a column when selecting “Screen Factors” as my output. However, there are also columns generated that are labeled as the Custom Formula that was called from within a custom formula. These columns have a value of 1 which I assume is intended to mean true.

I know that the number of output columns in screener is limited, so these non-essential custom formula labels impede the ability to output larger numbers of screen factors, crippling the screen.

I have tried generating a custom report but unfortunately it appears a custom report will not pass variable values.

Is there a way to develop a function that can be used to Hide these custom formula calls? Or get a way to have a custom report generate variable values??

PS: Nested Custom Formulas has helped me a lot. Great new feature…

2

We want to revisit the screener reports since they are very useful to understand the data. We’re mulling a few ideas.

In the meantime the only way to “control” which variables are displayed is to play around with the order of the rules.

3

Thank you. Just to be clear, the rule order won’t eliminate the column headers when setting a variable from a custom formula such as this Custom Formula

$ColumnHeader

SetVar(@D4,Close(0))

The screen factors output creates a column headed $ColumnHeader which is filled with 1. I understand the logic, just don’t need to see it.

If I make:
$ColumnHeader2 with the nested custom formula $ColumnHeader I get 2 columns both filled with ones. Of course if I simply called $ColumnHeader close(0) I would get that value in place of the number 1’s

This unnecessary column(s) are what I want to eliminate/hide…