Expression help

[danielnevitt]

Hi,

I have a table with the following expressions:

Position: Sum(pos_qty)/1000

Open Interest: sum(OPEN_INTEREST)

%: fabs(column(1)/column(2))

Is it possible to only show the results where the % calculation result is greater than 5%?

Regards,

Daniel

[ecolomer]

Yes you can use a if expression in order to check the result and put result in colour = with() for nothing see

[danielnevitt]

Hi Enrique,

Thank you for your response.

Sorry I am unsure how to create the if expression.  Would you mind sending me some example code?

Thanks,

Daniel

[sunny_talwar · Accepted solution]

May be like this

Position:

If(fabs(Sum(pos_qty)/1000/Sum(OPEN_INTEREST)) > 0.05, Sum(pos_qty)/1000)

Open Interest:

If(fabs(Sum(pos_qty)/1000/Sum(OPEN_INTEREST)) > 0.05, Sum(OPEN_INTEREST))

%:

If(fabs(Sum(pos_qty)/1000/Sum(OPEN_INTEREST)) > 0.05, fabs(Sum(pos_qty)/1000/Sum(OPEN_INTEREST)))

[ecolomer]

First possibility:

if(ffabs(column(1)/column(2)) > 0.05, fabs(column(1)/column(2)),' ')

then if the value is > 0,05 (5%) you write a blanc

Second:

you write your expression normaly and in the expression open + option and wirte in Text Color:

if(fabs(column(1)/column(2))< 0,05, white())

for put text color in white and not see them