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

[MK_QSL]

Num(Expression,'#0.00%')

[Peter_Cammaert]

How do you add parentheses to the small values? Are those negative values? In that case, add the % symbol to the format string in the Numbers tab.

[#4]

No its not working

my Expression is

=Num(if([Field (%)]/100<=0,0,

if([Field(%)]/100<1, '(' &[Field(%)]/100& ')',

if([Field(%)]/100>1,[Field(%)]/100))))

[#5]

Its default value if less than 0% will get parentheses.

Added % at num properties used but not working.

[#6]

Hi,

You can set in number tab like this.

[#7]

right but it showing to the values equal are more than 0%. like 0.00%, not to the values below Zero % which are in parentheses should be like (0.21)%

[MK_QSL]

Remove /100 and try it...

[#9]

Hi,

You can arrange in Fixed to 1 or 2 or 3.......

[anbu1984]

=if([Field (%)]/100<=0,0,

if([Field(%)]/100<1, '(' &[Field(%)]/100& ')',

if([Field(%)]/100>1,[Field(%)]/100))) & '%'