# Help creating a screen formula

I have a 15 stock portfolio with a dynamic weight. The weight in the portfolio is based in the "score". I wanted to create a screen formula that in some way, could mirror this weight, but I need some ideas on how to do so.

The formula is basically something like this: Target Weight = 4.78 + 0.12 * Score. So if the total score is 8, the screening formula should do be like this: Target Weight = 4.78 + 0.12 * 8 = 7.14%. ( linear regression - R^2 value of 0.98)

But fore some reason, when trying this in the screen: showvar(@Weight1,4.78+0.12*(@Totalscore)), it only shows the first number " 4.78", why?

Here is the table from Excel:

Ticker Action Name Shares Price Commission Amount Target Weight Score Rank Complete Formula weight TEST
BODI BUY The Beachbody Co., Inc. 2167 9.14 -19.81 19786.57 19.96 122.34 99.72 8.009310417 19.4608
SRTS BUY Sensus Healthcare, Inc. 1983 3.76 -7.46 7448.62 7.51 22.66 99.62 -37.5607299 7.4992
DSP BUY Viant Technology, Inc. 730 10.17 -7.42 7416.68 7.48 22.14 99.94 7.4368
SHIP BUY Seanergy Maritime Holdings Corp. 745 8.96 -6.68 6668.52 6.73 16.17 99.97 6.7204
APT BUY Alpha Pro Tech Ltd. 1040 6.19 -6.44 6431.16 6.49 14.41 99.68 6.5092
DR:CAN BUY Medical Facilities Corp. 797 7.56 -6.03 6019.14 6.07 11.04 99.84 6.1048
DRX:CAN BUY ADF Group, Inc. 969 5.94 -5.76 5750.49 5.8 8.91 99.87 5.8492
SNPO BUY Snap One Holdings Corp. 661 7.95 -5.25 5249.7 5.3 4.98 99.59 5.3776
VLN BUY Valens Semiconductor Ltd. 2355 2.19 -5.16 5152.29 5.2 4.22 99.78 5.2864
OPTN BUY OptiNose, Inc. 3381 1.5 -5.07 5066.43 5.11 3.51 99.53 5.2012
LTRX BUY Lantronix, Inc. 1490 3.4 -5.07 5060.93 5.1 3.41 99.75 5.1892
MRAM BUY Everspin Technologies, Inc. 609 8.04 -4.9 4891.46 4.93 1.95 99.56 5.014
BDT:CAN BUY Bird Construction, Inc. 349 13.61 -4.75 4745.35 4.79 0.74 99.91 4.8688