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]

Use image in place of the symbols like and change your expression like sample expression

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

Note:-

1.And make the expression as Image from Expression properties >> Display option >> Representaiton >> select (Image)

2. And then Image formatting >> Keep Aspect

[its_anandrjs]

You can also use this symbols but change your expression as image

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

Note:-

1.And make the expression as Image from Expression properties >> Display option >> Representaiton >> select (Image)

2. And then Image formatting >> Keep Aspect

[#4]

change your if condition as below:

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

[arulsettu]

result is

[its_anandrjs]

Try with this

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

[arulsettu]

below 6 i need show down arrow and above 6 need to show up arrow

[its_anandrjs]

Ok problem here is the values are in % then change your expression like multiple expression by 100

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

Or

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

[arulsettu]

hi Anand

below 6% down arrow

above 6% up arrow

now it showing up arrow for all percentage

[arulsettu]

for all down arrows showing now

for this if(Column(5) * 100 < 1, '▼','▲')