Percentage symbol

[#1]

Hi All

I have a field

I need to show % at end of values like (0.21)%. i set it in Number properties, also used num(Expression,'#.##0,00%') but its not working ,any expression level script or properties to change?

Regards

[Peter_Cammaert]

It works for me:

See the QVW document below.

Best,

Peter

[#3]

its calculation part need

[anlonghi2]

Hi Vamsi,

there is a parenthesis error, try with this:

Num(if([Field (%)]/100<=0,0, if([Field(%)]/100<1, '(' &[Field(%)]/100& ')',if([Field(%)]/100>1,[Field(%)]/100))),'#0.00%')

[#5]

Hi,

You can require like this (0.21)% . You can put Parenthesis (#,##0.0)%

[sudeepkm]

it is not working as you have set the positive number format only.

you need to set the negative format too.

num(Expression,'#.##0,00%;(#.##0,00)%')

[#7]

only 0% is showing and other values like (0.21) are missing.

[#8]

All null values are also showing %

[buzzy996]

try,simply u have to select from NUMBER tab- show in percent chek and modify ur expression accordingly.

[#10]

Thank you Peter but not working ..

[#11]

only 0% is showing and other values like (0.21) are missing.