How to get % symbol

[#1]

HI All ,

   Iam using a text box to display the difference between current year and previous year and  it is working fine , what i want to know is i want to display the % symbol infront of the symbol ,

The text box has the following expression :=(Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))*100))

Give me any suggestion

Thanks in advance

[its_anandrjs]

If the % symbol in numbers back side if this ok then you can use like

=Num (Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))    /100) , '#,##0%')

[#3]

If you are using a text box then simply concat symbol '%' with & operator.

=(your expression) &' %'

Regards,

Lalit

[#4]

hi,

Yu can use like this

=num( (Round((num(sum({$<Year = {$(=max(Year - 1))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} NET_AMOUNT), '$#,##0;($#,##0)')/num(sum({$<Year = {$(=max(Year))}, MonthNames = {"<=$(=max({<Year={$(=max(Year))}>} MonthNames))"}>} NET_AMOUNT), '$#,##0;($#,##0)'))*100)) ,'####,#%')

[vardhancse]

what ever expression we want to display in %,

Right click on chart->Number(Tab)->Select any thing other than expression default->Show in percentage

1.we need to check the Show in percentage check box

2. We need to remove * 100 in the expression.

because as we are selecting the Show in percentage it will also multiple the value in to 100.

and no not required in expression