Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
Hi,
have u tried with custom format method?
▲ #,##0;▼ #,##0
Then add in Text Color Expression:
if(sum(Amount)>0,Green(),Red())
Image please?
Hi Anil,
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.
Hi,
have u tried with custom format method?
▲ #,##0;▼ #,##0
Then add in Text Color Expression:
if(sum(Amount)>0,Green(),Red())
Thank you for your reply. Will try your method.
Regards,
Ashis
Ok sure, in this method exported output still remain number. so it should work as expected.