showing netive percent values in brackets

[kishorj1982]

Hi All,

PFA.

Can you please suggest how to show negative percent values in brackets upto 1 decimal place.

Thanks

[jonathandienst]

Like this:

Num(YourValue, '0.0%;(0.0%)')

[luismadriz]

May be this:

Num(Measure,'0.0%;[0.0%]')

I hope this helps

Luis

[luismadriz]

My bad J, you're too quick for me

[jonathandienst]

[kishorj1982]

no for 66% this is showing 0.7% which is not correct.

thanks

[kishorj1982]

no for 66% this is showing 0.7% which is not correct.