I have a straight table and one expression that has the following expression
if((Column(1) - Column(3)) >=0,
chr(9650),chr(9660) &' '&
num(($(vVariable1) - $(vVariable2)) /$(vVariable2),'#,##0.0%')
this is giving me up and down arrow as well as the percentage change . However this is turning into
text instead of numeric value. For that i am not able to sort the value.
Could you please help me how to make the whole expression as numeric .
One good way to understand this is text not number , going to presentation tab and that expression
Data(Numeric) right align and Data(Text) Center align.
Now if it is numeric it would be right align and if it is text it would come in the center.
My expression is showing in the center , so I come to know it is interpreting as text.
Due to security I can not show image, sorry for that.