Format Number as Percentage

[#1]

Hi Everyone

I need to dispaly number as percentage

Used num(value,'#,#0.0%')

does not work

[#2]

Try #.##0,00% or #,##0.00%, depending on your decimal and thousand separators.

[kaushiknsolanki]

Hi,

     What is the value of the field value and what you want to show.

     If its 100 and you want to show 100% then the best way is

     =Value&'%'

     The reason is when you use the num (Value,'#,##0.00%')

     This will multiply the number by 100 and then show as %.

     Meaning in our example is you use  num (Value,'#,##0.00%') where Value is 100

     Then the output will be 10,000%.

     Hope this is clear to you.

Regards,

Kaushik Solanki

[#4]

Hi Kaushik

I have used  =Value&'%' also but not getting the correct result.

All amounts are showed as 0.

[kaushiknsolanki]

Hi,

Is it possible for you to upload the application with some sample data, so that we can easily guide you to solution.

Regards,

Kaushik Solanki

[gajapathy74]

what is your selection in the "Number Format Settings" tab?

[#7]

It is Number

I changed it to Expression default.

now value & '%' is woking

Thanks