Decimal value less than 1% gives me wrong %.

[#1]

Hello, I need help. I am using this '##.#0%' to show XX.XX% format for my column. But when it becomes less than 1%, lets say 0.95% it should show me 0.95%. But its showing me 95%. Anyone

[#2]

Hi,

Try this format '##0.00%'

It will work.

[#3]

It works absolutely fine. But one thing, i need to represent Dot (.) with Comma (,) in percentage. How can this be possible?    

[swuehl]

Can't reproduce this here with 11.2 SR3:

=num(0.001,'##.#0%','.',',' )

in a text box shows 0.10%

[michael_maeuser]

go into the object properties. tab "numbers" there you can change it

[#6]

Hi,

Try this, '#,##0.00'.

[#7]

Hi,

Try this, '#,##0.00%'.

[christian77 · Accepted solution]

Hi:

Try this one instead '#.##0,00%' or  '#.##0,00 %' to have a nice space if you can.

I use this cause I use spanish notation.

[#9]

Couldn't get the desired output as 0,96%. Remember, I'm using it in Calculated Dimension, so there's no option for dimensions to change through object properties, only Expression have. Anyone again?

[michael_maeuser]

you can change it generally in the script. there are some SET variables. take a look at ThousandSep , DecimalSep