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

[#2]

You can surround your expression with num( <here your expression as argument 1>, <here the numberformat as argument 2>)

number format (when it is a percentage with 1 decimal can be ###,#

[#3]

Hi Roberto

   Thanks for ur reply , can u plz alter my expression , iam facing difficulty in understanding it , can u plz

[#4]

....

[satishkurra]

In Number Tab, Please check show in Percent Option

[CELAMBARASAN]

You can use like this also

='%' & (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))

[#7]

=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)) ,'####,#')

Assuming that , is your decimal separator.

If your decimal separator is a . (dot) then replace ####,# with ####.#

Celambarasan Adhimulam's option however seems a bit easier by the way.

[#8]

Thanks Celambarasan

  I copied and pasted the expression u gave , but its showing error , can u plz help me out

[its_anandrjs]

I believe what Celambarasan suggest like put in front of the 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))

[Anonymous]

Use:

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)'))),'$#,##0%;($#,##0%)')