percentage issue

[arulsettu]

in my straight table i am showing percentage like this

i used this code to show symbols

if(Column(5) < 1,'▼'&

Column(5) > 1,'▲')

but the result is 0.

what is my mistake?

[its_anandrjs]

Updated new query now check

Then try with

if( Column(5) * 100  < 6, 'qmem://<bundled>/BuiltIn/arrow_s_r.png', 'qmem://<bundled>/BuiltIn/arrow_n_g.png')

Or

if( Column(5) * 100  < 6, '▼' , '▲')

Note:- Or may be you have to use vice versa for values

[arulsettu]

hi anand

here is the app

[#4]

Arul,

Look at the true values of column 5 you can see that your expression is producing all negative values which you are masking by using the relative option, I would recalculate your percentages to be true values and this will work.

[arulsettu]

ok

[its_anandrjs]

In your application some values are not calculated because no values or may be it is negatives otherwise formula is correct or you can use Coumn(5) check your expression it is column(1) otherwise all seems fine. Check same formula with vise versa with < or > with formula.

Regards